Hi, I cannot set the connection timeout in ODBC using
SQLSetConnectAttr(m_hdbc,SQL_ATTR_CONNECTION_TIMEOUT, (void *)(0), 0); It always returns -1. I do not wish to modify the session_timeout parameter in the db server as other applications use the server and no connection timeout is inappropriate for them. Is there another way of disabling connection timeout at a per connection level in ODBC? Can I get the ODBC driver to fail instead of auto-reconnecting and losing the sqlmode setting? Thanks and regards, Ajit -----Original Message----- From: Ajit Aranha [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 4:06 PM To: '[EMAIL PROTECTED]' Subject: odbc connection timeout and SQLmode ORACLE Can I disable the connection timeout at a per connection level in ODBC? Regards, Ajit -----Original Message----- From: Ajit Aranha [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 2:52 PM To: '[EMAIL PROTECTED]' Subject: odbc connection timeout and SQLmode ORACLE SAPDB 7.3.30 with ODBC 7.3.00.00 Bug Description: When the ODBC connection times out the sqlmode setting is lost (the driver seems to auto reconnect but loses the SQLMODE ORACLE setting) See the attached ODBC driver trace. Note: Connection was established using SQLMODE ORACLE/Committed. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
