BUG #1992: ODBC error with PostgreSQL Win32 Clients

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
Thread:
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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Nicholas 2005-10-24 00:26:35 BUG #1993: Adding/subtracting negative time intervals changes time zone of result
Previous Message Mike Clements 2005-10-23 21:55:43 Re: BUG #1988: keygen not implemented