Problem with ODBC, ERROR - no error information is available

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

stibbett at zim.biz

 

 

 

Steve Tibbett.vcf
Description: Steve Tibbett.vcf

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html