severe error in ODBC driver 2 simult. connections
Posted in 2004
Topics: Connectivity: ODBC / JDBC / .NET
Hi, I'm using the ODBC driver "IBM INFORMIX 3.82 32 BIT" on Windows 2000. There are several VBScript-Jobs running simultaneously, and all of them connect to different Informix DBs (using a "DRIVER=..." Connection String). Generally everything works, but from time to time one job that has opened a connection to Server A suddenly retrieves data from Server B although it definitely hasn't opened any connection to Server B - but a second job did. I could reproduce this by creating two simple scripts that connect to two different servers in an endless loop, with random <100ms delays between CreateObject, cnn.open, set rst=cnn.execute..., rst.close and set cnn=Nothing. Result: after a few hundred loops, one of the scripts selects data from the wrong (the other) server. It seems as if some internal data in the driver manager is mixed!? The ODBC driver DOES support connecting to different databases simultaneously!? Can anyone clarify this or does anyone of you have a solution? Thanks a lot! Thomas