Re: ODBC problem with Microsoft Word and Excel - Mailing list pgsql-odbc

From Karl Denninger
Subject Re: ODBC problem with Microsoft Word and Excel
Date
Msg-id 025301c75f3b$481ae5e0$0d01a8c0@karlsdesktop
Whole thread Raw
In response to Re: ODBC problem with Microsoft Word and Excel  (George Weaver <gweaver@shaw.ca>)
List pgsql-odbc

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  karl@denninger.net

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

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [
mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of George Weaver
Sent: Monday, March 05, 2007 9:20
AM
To: pgsql-odbc@postgresql.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):

 

 

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

pgsql-odbc by date:

Previous
From: George Weaver
Date:
Subject: Re: ODBC problem with Microsoft Word and Excel
Next
From: greg.campbell@us.michelin.com
Date:
Subject: Re: MSysConf on PG 8.2 ?