dbTalk Databases Forums  

[BUGS] BUG #1992: ODBC error with PostgreSQL Win32 Clients

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1992: ODBC error with PostgreSQL Win32 Clients in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Paul Anderson
 
Posts: n/a

Default [BUGS] BUG #1992: ODBC error with PostgreSQL Win32 Clients - 10-24-2005 , 04:03 PM







The following bug has been logged online:

Bug reference: 1992
Logged by: Paul Anderson
Email address: pauland (AT) au1 (DOT) ibm.com
PostgreSQL version: 8.0.3
Operating system: Microsoft Windows XP Professional version 5.1.2600
Service Pack 1 Build 2600
Description: ODBC error with PostgreSQL Win32 Clients
Details:

Error may not be with Postress per say but with the ODBC diriver. Installed
pgw32cli-1[1].0.0.2-full.exe.

Select Version(); PostgreSQL 8.0.3 on i686-pc-mingw32, compiled by GCC
gcc.exe (GCC) 3.4.2 (mingw-special)

I created an ODBC connection using the Postgres driver through the ODBC
admin tool

Am running Microsoft Word 2002 SP2. I am trying to use the mail merge
functions to estalish a dynamic table link to Postgres.

This is done by choosing insert database from the mail merge menu

It brings up a dialog box to get data.
choose new source
choose ODBC DSN
choose the pre-creared PostgreSQL DSN
It returns an error "unable to obtain a list of tables from the data
source".

The same error can be reproduced through Excelif you choose Data|Import
External Data|Import Data

The ODBC connection DOES work if you choose
Data|Import External Data|New Database Query

My need is to dynamically embedd reports into a word documents so I can
distribute pre-formated reports so the excell option is not a viable option
for what I need.

The work around is to export the data from Postgres as tab delimeted text
files and then have word connect to the text files. This is workable but
cumbersome.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.