Hi Thomas, With 20 threads accessing binary data from the db using multiple statement handles(20)over 1 connection I get a lot of strange errors. The errors disappear if I stop using multiple statement handles per connection. (Note that it seems to work for upto 4 simultaneous threads (4 handles on 1 connection) and goes down for anything more than that) Note that I am running under windows 2000: The errors look like: ODBCSession::GetPiece:SQLGetData (a piece) : SQL_ERROR - [SAP AG][SQLOD32 DLL]General error. (errcode 0, sql state "S1000") ERROR: NuanceODBCSession::Commit:SQLEndTran : SQL_ERROR - (errcode 0, sql state "00000") ERROR: NuanceODBCSession::Commit:SQLEndTran : SQL_ERROR - (errcode 0, sql state "00000") ERROR: NuanceODBCSession::Commit:SQLEndTran : SQL_ERROR - (errcode 0, sql state "00000") ERROR: NuanceODBCSession::GetPiece:SQLGetData (a piece) : SQL_ERROR - [SAP AG][SQLOD32 DLL]General error. (errcode 0, sql state "S1000") ERROR: NuanceODBCSession::Fetch:SQLFetch : SQL_ERROR - [Microsoft][ODBC Driver Manager] Function sequence error (errcode 0, sql state "S1010") ERROR: NuanceODBCSession::Fetch:SQLFetch : SQL_ERROR - [Microsoft][ODBC Driver Manager] Function sequence error (errcode 0, sql state "S1010") ERROR: NuanceODBCSession::Fetch:SQLFetch : SQL_ERROR - [Microsoft][ODBC Driver Manager] Function sequence error (errcode 0, sql state "S1010") regards, Ajit
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
