I've 2 users connecting using ODBC and I'm getting an error

[Michael Hill]

Afternoon,

I've got 2 clients connecting to the database and running some queries simultaneously. Generally what happens is one user will get their report and the other will crash. The one that crashes the error returned is a general ODBC error.

I have just switched the tracer on the ODBC driver on and I get these errors:

jade 488-12ec ENTER SQLExecDirect
HSTMT 034DA370
UCHAR * 0x03226D20 [ -3] "CREATE TABLE if not exists tempcustomerMDH ( tcOid VARCHAR(15) NOT NULL PRIMARY KEY, tcCode VARCHAR(12) NOT NULL, tcName VARCHAR(50) NOT NULL, tcCompany INTEGER UNSIGNED, tcGroup BLOB NOT NULL, tcLevelGroup BLOB NOT NULL);\ 0"
SDWORD -3

jade 488-1404 ENTER SQLFreeHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 034DA370

jade 488-1404 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 034DA370

jade 488-12ec EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 034DA370
UCHAR * 0x03226D20 [ -3] "CREATE TABLE if not exists tempcustomerMDH ( tcOid VARCHAR(15) NOT NULL PRIMARY KEY, tcCode VARCHAR(12) NOT NULL, tcName VARCHAR(50) NOT NULL, tcCompany INTEGER UNSIGNED, tcGroup BLOB NOT NULL, tcLevelGroup BLOB NOT NULL);\ 0"
SDWORD -3

jade 488-12ec ENTER SQLNumResultCols
HSTMT 00000000
SWORD * 0x0385BA10

jade 488-1404 ENTER SQLAllocHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 034C1348
SQLHANDLE * 00B25D88

jade 488-12ec EXIT SQLNumResultCols with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
SWORD * 0x0385BA10

jade 488-1404 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 034C1348
SQLHANDLE * 0x00B25D88 ( 0x034da370)

jade 488-12ec ENTER SQLFetch
HSTMT 034DA370

jade 488-1404 ENTER SQLSetStmtOption
HSTMT 034DA370
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C

jade 488-12ec EXIT SQLFetch with return code -1 (SQL_ERROR)
HSTMT 034DA370

DIAG [HY010] [Microsoft][ODBC Driver Manager] Function sequence error (0)

If I'm reading these right it's telling me that user 2 is trying to create the file while user 1 is still using the handle for whatever it is currently running.

Can anyone confirm that this is correct and suggest a way to stop this from happening.

Cheers