Skip site navigation (1) Skip section navigation (2)

Re: ODBC problem with Microsoft Word and Excel

From: "Karl Denninger" <karl(at)denninger(dot)net>
To: "'George Weaver'" <gweaver(at)shaw(dot)ca>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC problem with Microsoft Word and Excel
Date: 2007-03-05 15:31:02
Message-ID: 025301c75f3b$481ae5e0$0d01a8c0@karlsdesktop (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc


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


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

Diving?  See HYPERLINK "" 

-----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):







"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

In response to

pgsql-odbc by date

Next:From: greg.campbellDate: 2007-03-05 22:36:37
Subject: Re: MSysConf on PG 8.2 ?
Previous:From: George WeaverDate: 2007-03-05 15:19:46
Subject: Re: ODBC problem with Microsoft Word and Excel

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group