Write conflict with driver 5.1.9
RAPPAZ Francois <[email protected]> Tue, 22 Nov 2011 12:29:41 +0100
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Using version 5.1.9 of the driver, I had several write conflict message when working on a sinle table attached in MS Access 2010. I use the following file dsn [ODBC] DRIVER=MySQL ODBC 5.1 Driver UID=... SERVER=... PORT=3306 OPTION=4210714 DATABASE=... PWD=... With the 3.5.1.23 driver none of these messages occurred. I turn the debug on I have tried to extract the same sequence for the two drivers. With 5.1.9 I could not change a value in this reccord. Comparing the two debug list, it seems that the following are not given with driver 5.1.9 refunifr db8-e28 ENTER SQLTransact HENV 0x00286CE8 HDBC 0x0028A290 UWORD 0 <SQL_COMMIT> refunifr db8-e28 EXIT SQLTransact with return code 0 (SQL_SUCCESS) HENV 0x00286CE8 HDBC 0x0028A290 UWORD 0 <SQL_COMMIT> refunifr db8-e28 ENTER SQLSetConnectOptionW HDBC 0x0028A290 SQLINTEGER 102 <SQL_AUTOCOMMIT> SQLPOINTER 1 <SQL_AUTOCOMMIT_ON> The debug list for the same reccord is Driver 3.51.23 refunifr db8-e28 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03BAEF00 UWORD 4 SWORD -8 <SQL_C_WCHAR> PTR 0x0ED544F4 [ 42] "PHYSIOLOGY & BEHAVIOR" SQLLEN 32000 SQLLEN * 0x004295A8 (42) refunifr db8-e28 ENTER SQLGetData HSTMT 0x03BAEF00 UWORD 5 SWORD -8 <SQL_C_WCHAR> PTR 0x0ED544F4 SQLLEN 32000 SQLLEN * 0x004295A8 refunifr db8-e28 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03BAEF00 UWORD 5 SWORD -8 <SQL_C_WCHAR> PTR 0x0ED544F4 [ 8] "2011" SQLLEN 32000 SQLLEN * 0x004295A8 (8) refunifr db8-e28 ENTER SQLGetData HSTMT 0x03BAEF00 UWORD 6 SWORD -8 <SQL_C_WCHAR> PTR 0x0ED544F4 SQLLEN 32000 SQLLEN * 0x004295A8 refunifr db8-e28 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03BAEF00 UWORD 6 SWORD -8 <SQL_C_WCHAR> PTR 0x0ED544F4 [ 6] "104" SQLLEN 32000 SQLLEN * 0x004295A8 (6) refunifr db8-e28 ENTER SQLGetData HSTMT 0x03BAEF00 UWORD 7 SWORD -8 <SQL_C_WCHAR> PTR 0x0ED544F4 SQLLEN 32000 SQLLEN * 0x004295A8 refunifr db8-e28 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03BAEF00 UWORD 7 SWORD -8 <SQL_C_WCHAR> PTR 0x0ED544F4 [ 2] "5" SQLLEN 32000 SQLLEN * 0x004295A8 (2) refunifr db8-e28 ENTER SQLGetData HSTMT 0x03BAEF00 UWORD 8 SWORD -8 <SQL_C_WCHAR> PTR 0x0ED544F4 SQLLEN 32000 SQLLEN * 0x004295A8 refunifr db8-e28 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03BAEF00 UWORD 8 SWORD -8 <SQL_C_WCHAR> PTR 0x0ED544F4 [ 28] "770 777 OCT 24" SQLLEN 32000 SQLLEN * 0x004295A8 (28) refunifr db8-e28 ENTER SQLGetData HSTMT 0x03BAEF00 UWORD 9 SWORD 5 <SQL_C_SHORT> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x004295A8 refunifr db8-e28 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03BAEF00 UWORD 9 SWORD 5 <SQL_C_SHORT> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x004295A8 (2) refunifr db8-e28 ENTER SQLGetData HSTMT 0x03BAEF00 UWORD 10 SWORD 11 <SQL_C_TIMESTAMP> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x004295A8 refunifr db8-e28 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03BAEF00 UWORD 10 SWORD 11 <SQL_C_TIMESTAMP> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x004295A8 (16) refunifr db8-e28 ENTER SQLGetData HSTMT 0x03BAEF00 UWORD 11 SWORD 11 <SQL_C_TIMESTAMP> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x004295A8 refunifr db8-e28 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03BAEF00 UWORD 11 SWORD 11 <SQL_C_TIMESTAMP> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x004295A8 (-1) refunifr db8-e28 ENTER SQLFreeStmt HSTMT 0x03BAEF00 UWORD 0 <SQL_CLOSE> refunifr db8-e28 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 0x03BAEF00 UWORD 0 <SQL_CLOSE> refunifr db8-e28 ENTER SQLTransact HENV 0x00286CE8 HDBC 0x0028A290 UWORD 0 <SQL_COMMIT> refunifr db8-e28 EXIT SQLTransact with return code 0 (SQL_SUCCESS) HENV 0x00286CE8 HDBC 0x0028A290 UWORD 0 <SQL_COMMIT> refunifr db8-e28 ENTER SQLSetConnectOptionW HDBC 0x0028A290 SQLINTEGER 102 <SQL_AUTOCOMMIT> SQLPOINTER 1 <SQL_AUTOCOMMIT_ON> refunifr db8-e28 EXIT SQLSetConnectOptionW with return code 0 (SQL_SUCCESS) HDBC 0x0028A290 SQLINTEGER 102 <SQL_AUTOCOMMIT> SQLPOINTER 1 <SQL_AUTOCOMMIT_ON> refunifr db8-e28 ENTER SQLFreeStmt HSTMT 0x03BAEF00 UWORD 1 <SQL_DROP> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Driver 5.1.9 refunifr 1244-744 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03B6CE58 UWORD 4 SWORD -8 <SQL_C_WCHAR> PTR 0x0ECD4654 [ 42] "PHYSIOLOGY & BEHAVIOR" SQLLEN 32000 SQLLEN * 0x002E2C60 (42) refunifr 1244-744 ENTER SQLGetData HSTMT 0x03B6CE58 UWORD 5 SWORD -8 <SQL_C_WCHAR> PTR 0x0ECD4654 SQLLEN 32000 SQLLEN * 0x002E2C60 refunifr 1244-744 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03B6CE58 UWORD 5 SWORD -8 <SQL_C_WCHAR> PTR 0x0ECD4654 [ 8] "2011" SQLLEN 32000 SQLLEN * 0x002E2C60 (8) refunifr 1244-744 ENTER SQLGetData HSTMT 0x03B6CE58 UWORD 6 SWORD -8 <SQL_C_WCHAR> PTR 0x0ECD4654 SQLLEN 32000 SQLLEN * 0x002E2C60 refunifr 1244-744 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03B6CE58 UWORD 6 SWORD -8 <SQL_C_WCHAR> PTR 0x0ECD4654 [ 6] "104" SQLLEN 32000 SQLLEN * 0x002E2C60 (6) refunifr 1244-744 ENTER SQLGetData HSTMT 0x03B6CE58 UWORD 7 SWORD -8 <SQL_C_WCHAR> PTR 0x0ECD4654 SQLLEN 32000 SQLLEN * 0x002E2C60 refunifr 1244-744 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03B6CE58 UWORD 7 SWORD -8 <SQL_C_WCHAR> PTR 0x0ECD4654 [ 2] "5" SQLLEN 32000 SQLLEN * 0x002E2C60 (2) refunifr 1244-744 ENTER SQLGetData HSTMT 0x03B6CE58 UWORD 8 SWORD -8 <SQL_C_WCHAR> PTR 0x0ECD4654 SQLLEN 32000 SQLLEN * 0x002E2C60 refunifr 1244-744 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03B6CE58 UWORD 8 SWORD -8 <SQL_C_WCHAR> PTR 0x0ECD4654 [ 28] "770 777 OCT 24" SQLLEN 32000 SQLLEN * 0x002E2C60 (28) refunifr 1244-744 ENTER SQLGetData HSTMT 0x03B6CE58 UWORD 9 SWORD 5 <SQL_C_SHORT> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x002E2C60 refunifr 1244-744 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03B6CE58 UWORD 9 SWORD 5 <SQL_C_SHORT> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x002E2C60 (2) refunifr 1244-744 ENTER SQLGetData HSTMT 0x03B6CE58 UWORD 10 SWORD 11 <SQL_C_TIMESTAMP> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x002E2C60 refunifr 1244-744 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03B6CE58 UWORD 10 SWORD 11 <SQL_C_TIMESTAMP> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x002E2C60 (16) refunifr 1244-744 ENTER SQLGetData HSTMT 0x03B6CE58 UWORD 11 SWORD 11 <SQL_C_TIMESTAMP> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x002E2C60 refunifr 1244-744 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 0x03B6CE58 UWORD 11 SWORD 11 <SQL_C_TIMESTAMP> PTR <unknown type> SQLLEN 32000 SQLLEN * 0x002E2C60 (-1) refunifr 1244-744 ENTER SQLFreeStmt HSTMT 0x03B6CE58 UWORD 0 <SQL_CLOSE> refunifr 1244-744 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 0x03B6CE58 UWORD 0 <SQL_CLOSE> refunifr 1244-744 ENTER SQLFreeStmt HSTMT 0x03B6CE58 UWORD 1 <SQL_DROP> refunifr 1244-744 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 0x03B6CE58 UWORD 1 <SQL_DROP> refunifr 1244-744 ENTER SQLFreeStmt HSTMT 0x03B6C808 UWORD 1 <SQL_DROP> Shall I drop the 5.1 driver and stick to old version ? Thanks for any advices François -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]