BUG #1992: ODBC error with PostgreSQL Win32 Clients

Lists: pgsql-bugs
From: "Paul Anderson" <pauland(at)au1(dot)ibm(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1992: ODBC error with PostgreSQL Win32 Clients
Date: 2005-10-24 00:21:50
Message-ID: 20051024002150.A44E3F0FED@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1992
Logged by: Paul Anderson
Email address: pauland(at)au1(dot)ibm(dot)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.