Hi,

I'm having some difficulties with Informix ODBC drivers regarding the pseudo column ROWID returned from the ODBC call SQLSpecialColumns.

Is it possible to override the result from SQLSpecialColumns to return the table's primary key in place of the ROWID column as the BES_ROW_ID?

For DataDirect ODBC drivers the Workarounds=512 registry setting appears to provide this functionality - is anyone aware of a workaround for the IBM Informix ODBC Driver?

http://media.datadirect.com/download...tml/wwhelp.htm

Cheers,
mix