Problems with setting SQL_LOGIN_TIMEOUT

Posted in 2003

Topics: Connectivity: ODBC / JDBC / .NET

Christian_Fechter@msg.de — Fri, 6 Jun 2003 10:37:14 +0200 — source: Usenet: comp.databases.informix

This is a multipart message in MIME format. --=_alternative 002EE6DCC1256D3D_= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable i'm using an informix csdk (2.81) for windows and when i try to set the=20 SQL=5FLOGIN=5FTIMEOUT - attribute,=20 i get the SQLRETURN -1.=20 i don't understand, why setting this connection attribute is not=20 successfull. this is my sample code: /*Allocate environment handle */ rcSQL =3D SQLAllocHandle( SQL=5FHANDLE=5FENV , SQL=5FNULL=5FHANDLE, &henv= ); SQL=5FCHECK=5FRC( EXTTBLREQ=5FERR=5FEXT=5FODBC=5FERROR ,=20 "could not create ODBC handle" ); =20 /* Set the ODBC version environment attribute */ rcSQL =3D SQLSetEnvAttr(henv, SQL=5FATTR=5FODBC=5FVERSION, (void*)SQL=5FO= V=5FODBC3,=20 0); SQL=5FCHECK=5FRC( EXTTBLREQ=5FERR=5FEXT=5FODBC=5FERROR , "could not set O= DBC=20 version" ); /* Allocate connection handle */ rcSQL =3D SQLAllocHandle(SQL=5FHANDLE=5FDBC, henv, &hdbc); SQL=5FCHECK=5FRC( EXTTBLREQ=5FERR=5FEXT=5FODBC=5FERROR , "could not alloc= ate=20 connection handle" ); /* Set login timeout to 5 seconds. */ rcSQL =3D SQLSetConnectAttr(hdbc, SQL=5FLOGIN=5FTIMEOUT, (SQLPOINTER)5, 0= ); SQL=5FCHECK=5FRC( EXTTBLREQ=5FERR=5FEXT=5FODBC=5FERROR , "could not set l= ogin=20 timeout" ); can anybody help me? Mit freundlichen Gr=FC=DFen / Kind Regards Christian Fechter =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F Gesch=E4ftsbereich Versicherungen msg systems ag Robert-B=FCrkle-Stra=DFe 1 D - 85737 Ismaning / M=FCnchen Telefon: +49 (0) 89/961 01 -12 23 Telefax: +49 (0) 89/961 01 -11 13 mailto: fechterc@msg.de http://www.msg-systems.com =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F --=_alternative 002EE6DCC1256D3D_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable i'm using an informix csdk (2.81) fo= r windows and when i try to set the  SQL=5FLOGIN=5FTIMEOUT - attribute= , i get the SQLRETURN   -1. </fon= t> i don't understand, why setting this= connection attribute is not successfull. this is my sample code:   /*Allocate environment handle= */   rcSQL =3D SQLAllocHandle( SQL= =5FHANDLE=5FENV , SQL=5FNULL=5FHANDLE, &henv);   SQL=5FCHECK=5FRC( EXTTBLREQ= =5FERR=5FEXT=5FODBC=5FERROR ,           &= nbsp;     "could not create ODBC handle" );       /* Set the ODBC version envir= onment attribute */   rcSQL =3D SQLSetEnvAttr(henv,= SQL=5FATTR=5FODBC=5FVERSION, (void*)SQL=5FOV=5FODBC3, 0);   SQL=5FCHECK=5FRC( EXTTBLREQ= =5FERR=5FEXT=5FODBC=5FERROR , "could not set ODBC version" );</fo= nt>   /* Allocate connection handle= */   rcSQL =3D SQLAllocHandle(SQL= =5FHANDLE=5FDBC, henv, &hdbc);   SQL=5FCHECK=5FRC( EXTTBLREQ= =5FERR=5FEXT=5FODBC=5FERROR , "could not allocate connection handle&qu= ot; );   /* Set login timeout to 5 sec= onds. */   rcSQL =3D SQLSetConnectAttr(h= dbc, SQL=5FLOGIN=5FTIMEOUT, (SQLPOINTER)5, 0);   SQL=5FCHECK=5FRC( EXTTBLREQ= =5FERR=5FEXT=5FODBC=5FERROR , "could not set login timeout" );</f= ont> can anybody help me? Mit freundlichen Gr=FC=DFen / Kind Regards Christian Fechter =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F Gesch=E4ftsbereich Versicherungen msg systems ag Robert-B=FCrkle-Stra=DFe 1 D - 85737 Ismaning / M=FCnchen Telefon: +49 (0) 89/961 01 -12 23 Telefax: +49 (0) 89/961 01 -11 13 mailto: fechterc@msg.de http://www.msg-systems.com ; =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F --=_alternative 002EE6DCC1256D3D_=--

Problems with setting SQL_LOGIN_TIMEOUT

Related threads

Your privacy choices