Hi - I'm using ASP.NET to write an app that's talking to a Postgres back end through ODBC.
It's been working pretty well, except that lately I run into this problem when trying to open a connection.
I get an error exception thrown by the .NET framework's OdbcConnection clsas, with no information about the error.
I turned on logging, and when the error was happening, this is what was there:
[884]CONN ERROR: func=PGAPI_GetInfo30, desc='', errnum=209, errmsg='Unrecognized key passed to SQLGetInfo30.'
[884]CONN ERROR: func=SQLGetInfo30, desc='', errnum=209, errmsg='Unrecognized key passed to SQLGetInfo30.'
I determined from the ODBC log that the unrecognized key is SQL_DTC_TRANSITION_COST.
Anyone seen this? I don't know why it's only asking for SQL_DTC_TRANSITION_COST in some situations and not others.. seems like supporting this in SQLGetInfo30 would be a reasonable fix but I'm not sure why it's happening at all. I was playing with the connection pooling settings, maybe that's what started it, but I turned that back off and even still it only happens occasionally (but once it starts happening, it keeps happening until I restart the ASP.NET worker process).
Thanks
--
Steve Tibbett