Re: ODBC problem with Microsoft Word and Excel

Interesting.

If I create a blank “.UDL” file I can then stick in that and it appears to
work, but its SEVERELY limited.

I can’t get at anything from Word EXCEPT for the single database that I
defined in the SQL setup in “Data Sources” – and I can only have one on the
machine! This is a potential problem of course…… there’s a lot more than
one database on the SQL server…..

But – it DOES appear to work for mail merge this way – its just kludgy as
heck.

-- Karl Denninger HYPERLINK "mailto:karl(at)denninger(dot)net"karl(at)denninger(dot)net

Diving? See HYPERLINK "http://www.scubaforum.org"http://www.scubaforum.org

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of George Weaver
Sent: Monday, March 05, 2007 9:20 AM
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] ODBC problem with Microsoft Word and Excel

Original Message From "Karl Denninger"

>The part I don't understand is that I enabled logging and it appears to be
>returning the table list! Immediately after I attempt the connect from
>either EXCEL or WORD I pulled the logfiles.

I don't think the problem resides on the PostgreSQL side of things but the
Office side. From my experience and from what I can gather Office needs a
separate file (.udl .odc, etc) in order to display the results properly.

The discussion here might provide some further insight (first topic -
Subject: Re: Mail Merge to SQL Server without using an external ODC):

HYPERLINK
"http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?que
ry=dsn+less&dg=microsoft.public.word.mailmerge.fields&cat=en_us_ee88ce09-9e3
4-4b0c-8aba-2e17252d39bc&lang=en&cr=us&pt=&catlist=&dglist=&ptlist=&exp=&slo
c=en-us"http://www.microsoft.com/communities/newsgroups/list/en-us/default.a
spx?query=dsn+less&dg=microsoft.public.word.mailmerge.fields&cat=en_us_ee88c
e09-9e34-4b0c-8aba-2e17252d39bc&lang=en&cr=us&pt=&catlist=&dglist=&ptlist=&e
xp=&sloc=en-us

HTH

George

"When you see a new trail, or a footprint you do not know,
follow it to the point of knowing."
- Uncheedah, Grandmother of Ohiyesa

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.7/710 - Release Date: 3/4/2007
1:58 PM