ODBC problem - database working, but ODBC shouts error

[dejan]

I keep getting this error today on our (Windows) web server which serves ASP...

Error type: [Ingres][Ingres ODBC Driver]Ingres API failure probably to due to transaction already abnormally terminated (0x80004005)[Ingres][Ingres ODBC Driver]Ingres API failure probably to due to transaction already abnormally terminated

Developers who work on ASP pages use ODBC to connect to a remote Ingres database running on GNU/Linux.

The ODBC driver they use is the driver from Ingres 2.6 .

This error started appearing when Ingres database server restarted, and nothing could fix it. The last thing we are going to try is to restart the whole web server.
PS. we tested connection to the database on this Windows server and it worked without problems in the command line...

Can someone enlighten me what is the problem here, and how to prevent it in the future.

Thanks in advance.

[loera01]

Hello Dejan,

It's really hard to say what the problem is based on your description. The message means that either the client or the server aborted the transaction, but more information would be required to figure out why the transaction was cut short.

To diagnose the problem, I would first recommend an ODBC trace of one of the clients, and, ideally, the server:

INGSETENV II_ODBC_LOG C:\TEMP\ODBC.LOG
INGSETENV II_ODBC_TRACE 5
INGSETENV II_API_TRACE 5

You may then post the API log(s) here in the Forum or e-mail me at Ralph.Loen@ingres.com.

Regards, Ralph Loen