ConnectionTimeout Property of ADODB.Connection object using Informix Provider
Posted in 2003
Hi,
I am trying to determine why the ConnectionTimeout property of the
ADODB.Connection object (coded in ASP) is not working with my Informix
Provider? I have coded an ASP Web application that tries to connect to
a hard-coded list of ODBC DSN's, one at a time, in order. If the first
connection attempt fails, then subsequent connection attempts are made
to the next DSN, and so on. I want to give each attempt only 5 seconds
before aborting and moving on to the next DSN.
Here is my system information:
ASP SERVER:
-Windows 2000 Professional IIS5.0 (with the latest service packs
installed)
-INFORMIX 3.80 32 BIT ODBC Driver
INFORMIX SERVER:
-Informix Dynamic Server 2000 Version 9.21.UC2
My code works fine (skips to the next DSN) when the DSN passed to the
open() method is not a valid ODBC DSN or when the DSN is pointing to
an Informix Server which is not accesseable (I unplug my network cable
then try to run the asp page). My code fails/times out when I plug in
my network cable, execute an onmode -ky on the Informix Server, then
run the asp page (because the connection attempt never stops trying to
connect). I don't mean to be so rudimentary in my explanation, but I
don't wan't to assume anything in my description, so i've described
exactly what steps I took.
Can I even use the ConnectionTimeout property or is there another
Informix-specific property I can use to set the connection timeout?
Thanks For Your Help,
Nate