RE: ODBC to informix from IIS4 ASP hangs
Posted in 1999
Topics: Connectivity: ODBC / JDBC / .NET
I think I am having a similar problem... I have not heard of any solutions from C.D.I. other than "try our product..." I have a few ideas I plan to try tomorrow. If you don't hear from me, drop me a note. Paul Schaeflein Mgr. Financial Systems Sidley & Austin -----Original Message----- From: Murray Bathgate [mailto:Murray.Bathgate@nz.eds.com] Sent: Monday, March 08, 1999 2:50 PM To: informix-list@iiug.org Subject: ODBC to informix from IIS4 ASP hangs We are experiencing intermittent service hangs when accessing Informix via ODBC from an active server page running on IIS 4 . Is anyone succesfully running a simalar configuration , and/or experiencing the same type of problem . We have been informed by the vendors that it is likly an incompatility between the informix odbc2.5 and microsoft odbc3.0 compliant drivers . Our concern is that the hangs are at random periods , are not load related , and not specific to any specific asp page . eg the page will hang only sometimes even thopugh queries are identical . When the process hangs , it is noted that the DB is still accessable through direct access . Has anyone had success using the intersolv odbc3.0 drivers with ASP pages ? Thanks in advance Murray Murray.Bathgate@nz.eds.com
Judging from your post, I understand you have IIS working atleast partially working with Informix. Could you send me setup, we have been trying with the following setup, but have not been able to make a connection: *NT Server 4.0 SP4, informix CLI 2.8 AND intersolv 3.01 ODBC drivers (both don't work), IIS 4 *Standard Engine 7 running on SCO OpenServer, transaction logs set to ON, (we had no problems when transactions were off, however some other department needed them to be set, so there you go :) ) Informix suggested upgrading to the Online Engine (no suprise there) Many thanks for any information you can give me, Sven Eric