Unix Technical Forum

BUG #1992: ODBC error with PostgreSQL Win32 Clients

This is a discussion on BUG #1992: ODBC error with PostgreSQL Win32 Clients within the pgsql Bugs forums, part of the PostgreSQL category; --> The following bug has been logged online: Bug reference: 1992 Logged by: Paul Anderson Email address: pauland@au1.ibm.com PostgreSQL version: ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Bugs

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 10:21 AM
Paul Anderson
 
Posts: n/a
Default BUG #1992: ODBC error with PostgreSQL Win32 Clients


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.

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:07 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com