Microsoft.Data.ODBC, System.Data.ODBC, psqlodbc: where's the bug?
I’m running a bad problem with an aspnet
application using psqlodbc to connect to a Postgres db. Apparently in a random
manner I get a bad “server application unavailable” from my aspnet
app, and in Eventlog I find three records:
COM+, event id 4194
The system has
called a custom component and that component has failed and generated an
exception. This indicates a problem with the custom component. Notify the
developer of this component that a failure has occurred and provide them with
the information below.
nature of this error has caused the process to terminate.
COM+, Event id 4097
environment has detected an inconsistency in its internal state. Please contact
Microsoft Product Support Services to report this error. ***
Error in __FILE__(926): Application image dump failed.
ASPNET 1.1.4322.0, event id 1000
aspnet_wp.exe (PID: 3368)
Postgres is version 7.4.1 running on a Fedora 3
server, aspnet is on a Windows 2000 server.
The same application has been running for over an
year on framework 1.0 with Microsoft.Data.Odbc class and psqlodbc 7.03.200.
I’m now using framework 1.1.4322, and tried
both Microsoft.Data.Odbc and System.Data.Odbc, with psqlodbc 7.03.200 and the
latest 8.00.101 with the same identical result.
Using the odbc driver to trace the error, I found I
get this one:
CONN ERROR: func=PGAPI_GetInfo30, desc='',
errnum=209, errmsg='Unrecognized key passed to SQLGetInfo30.