BUG #1992: ODBC error with PostgreSQL Win32 Clients - Mailing list pgsql-bugs

From Paul Anderson
Subject BUG #1992: ODBC error with PostgreSQL Win32 Clients
Date
Msg-id 20051024002150.A44E3F0FED@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: "Jean-Claude Caty"
Date:
Subject: BUG #1995: problem in createuser's french traduction
Next
From: Jari Aalto
Date:
Subject: Re: BUG #1986: Please include ONE BIG .txt and .HTML file in *docs*.tar.gz