The following bug has been logged online:
Bug reference: 1992
Logged by: Paul Anderson
Email address: pauland@au1.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.