J
jhobson
Guest
I finally found the problem. Sorry it took so long. The application is setting a query timeout of 30 seconds. EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS) SQLHSTMT 0x000000DD426434E0 SQLINTEGER 0 SQLPOINTER 30 SQLINTEGER -5 When the service fails to respond within 30 seconds, the D2C ODBC driver retries the SELECT statement, which results in the session-in-use error. Can the query timeout setting for the application be increased? If not, you can set the QueryTimeout in your data source to -1. This will cause any setting of query timeout by the application to be ignored, meaning queries will * not * be timed out. I hope this helps. Thanks, John
Continue reading...
Continue reading...