vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |