Informix NativeError : -930 ODBC issue
Posted in 2003
Does anyone know why the Windows Informix ODBC (3.80) driver tries to open the previous DSN on a second connection attempt after the first connection attempt fails with NativeError : -930 or -908? (Please see the 2nd 'zscoob.optx.com' in my output below...) I am trying to setup a list of DSN names that my asp Web application can use so that if the current connection fails, the application can try to connect to the next DSN, and so on. Thanks in advance on behalf of myself and anyone else who ever has this problem, Nate... Here is an output of what is happening in my code (for reference): SETTING APPLICATION("03__REPORT_ODBC")... (2) Connecting to: 'DSN=scoob_web'...FAILED! REASONS: [object Error] Error : [Informix][Informix ODBC Driver][Informix]Cannot connect to database server (zscoob.optx.com). Help Context : 0 Help File : NativeError : -930 Number : -2147217843 Source : Microsoft OLE DB Provider for ODBC Drivers SQLState : 08004 Error : [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed Help Context : 0 Help File : NativeError : 0 Number : -2147217843 Source : Microsoft OLE DB Provider for ODBC Drivers SQLState : IM006 END REASONS (2) Connecting to: 'DSN=optqa1'...FAILED! REASONS: [object Error] Error : [Informix][Informix ODBC Driver][Informix]Cannot connect to database server (zscoob.optx.com). Help Context : 0 Help File : NativeError : -930 Number : -2147217843 Source : Microsoft OLE DB Provider for ODBC Drivers SQLState : 08004 Error : [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed Help Context : 0 Help File : NativeError : 0 Number : -2147217843 Source : Microsoft OLE DB Provider for ODBC Drivers SQLState : IM006 END REASONS FAILED TO SET APPLICATION("03__REPORT_ODBC")! END