Win32 ODBC 6.5 driver and PostgreSQL 7.0 Foreign Key s

From: "Panon, Paul-Andre" <Paul-AndrePanon(at)SierraSystems(dot)com>
To: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Win32 ODBC 6.5 driver and PostgreSQL 7.0 Foreign Key s
Date: 2000-09-15 21:29:37
Message-ID: D1D937EF0E0FD311ADC800600815C3030262B5BB@SVVAN330
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hello,

I am trying to use the win32 ODBC driver to allow ErWin to connect to a
PostgresSQL 7.0 for database creation/synchronization. The PostgreSQL driver
seems to be choking on the first SQLGetInfo call from Erwin. Here follows
the result from connection logging:

conn=46333984,
SQLDriverConnect(out)='DSN=HoldingTank;DATABASE=holdingtank;SERVER=exhibitx.
area51.sierrasys.com;PORT=5432;UID=...;PWD=...;READONLY=0;PROTOCOL=6.4;FAKEO
IDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
CONN ERROR: func=SQLGetInfo, desc='', errnum=209, errmsg='Unrecognized key
passed to SQLGetInfo.'
------------------------------------------------------------
henv=46139368, conn=46333984, status=1, num_stmts=16
sock=46139384, stmts=46139424, lobj_type=-999
---------------- Socket Info -------------------------------
socket=228, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=46209888, buffer_out=46205784
buffer_filled_in=33, buffer_filled_out=0, buffer_read_in=32
conn=46333984, SQLDisconnect

Unfortunately, the key (fInfoType) is not being logged so I'm not sure what
Erwin is asking. After Erwin gets this error message, it gives up on the
driver and uses it at the simplest level it can with no support for foreign
or primary keys. My next step seems to be to modify the code to log the
fInfoType and try to fix the problem. Before I go that far however, has the
win32 ODBC driver (6.50) been updated to correctly understand and report
PostgreSQL 7.0 Foreign Key contraints generated during either a CREATE TABLE
or an ALTER TABLE...ADD CONSTRAINT statement? If it hasn't, it's probably
not worth my time to track down the first problem.

Thank you,

Paul-Andre Panon

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jamie Walker 2000-09-16 09:15:05 Re: Converting MS-Access To Postgresql
Previous Message Tom Lane 2000-09-15 19:10:09 Re: Perl Interface is printing NOTICE's on stderr