BUG #1992: ODBC error with PostgreSQL Win32 Clients
От | Paul Anderson |
---|---|
Тема | BUG #1992: ODBC error with PostgreSQL Win32 Clients |
Дата | |
Msg-id | 20051024002150.A44E3F0FED@svr2.postgresql.org обсуждение исходный текст |
Список | 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 по дате отправления: