mysql odbc
"Ritchie DeComa" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
I have installed the mysql 3.51 odbc, tested the connection by pressing the test button - and it gives me "success; connection was made". Unfortunately, when I go to Access 2000 and link through the ODBC, it doesn't give me any errors; instead, it just doesn't give me the list of tables[which is only the two I have created] and returns to Access like nothing took place . What am I missing? I did run the tracer, but I can't read all the jarble. I've provided you with the "jarble" because you have more experience: MSACCESS 75c-1f0 ENTER SQLAllocEnv HENV * 0012C77C MSACCESS 75c-1f0 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS) HENV * 0x0012C77C ( 0x079f1540) MSACCESS 75c-1f0 ENTER SQLAllocConnect HENV 079F1540 HDBC * 0012C88C MSACCESS 75c-1f0 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 079F1540 HDBC * 0x0012C88C ( 0x079f15e8) MSACCESS 75c-1f0 ENTER SQLSetConnectOption HDBC 079F15E8 SQLINTEGER 103 <SQL_LOGIN_TIMEOUT> SQLPOINTER 0x00000014 MSACCESS 75c-1f0 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 079F15E8 SQLINTEGER 103 <SQL_LOGIN_TIMEOUT> SQLPOINTER 0x00000014 (BADMEM) MSACCESS 75c-1f0 ENTER SQLSetConnectAttrW SQLHDBC 079F15E8 SQLINTEGER 30002 <unknown> SQLPOINTER [Unknown attribute 30002] SQLINTEGER -3 MSACCESS 75c-1f0 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 079F15E8 SQLINTEGER 30002 <unknown> SQLPOINTER [Unknown attribute 30002] SQLINTEGER -3 MSACCESS 75c-1f0 ENTER SQLDriverConnectW HDBC 079F15E8 HWND 001A03BE WCHAR * 0x1F7A9D2C [ -3] "******\ 0" SWORD -3 WCHAR * 0x1F7A9D2C SWORD 2 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> MSACCESS 75c-1f0 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 HWND 001A03BE WCHAR * 0x1F7A9D2C [ -3] "******\ 0" SWORD -3 WCHAR * 0x1F7A9D2C SWORD 2 SWORD * 0x00000000 UWORD 1 <SQL_DRIVER_COMPLETE> MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 9 <SQL_ODBC_API_CONFORMANCE> PTR 0x0012C8B0 SWORD 2 SWORD * 0x0012C8A8 MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 9 <SQL_ODBC_API_CONFORMANCE> PTR 0x0012C8B0 (1) SWORD 2 SWORD * 0x0012C8A8 (2) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 6 <SQL_DRIVER_NAME> PTR 0x0012C7C0 SWORD 200 SWORD * 0x0012C8A8 MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 6 <SQL_DRIVER_NAME> PTR 0x0012C7C0 [ 26] "libmyodbc3.so" SWORD 200 SWORD * 0x0012C8A8 (26) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x0012C78A SWORD 2 SWORD * 0x0012C35C MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x0012C78A (2) SWORD 2 SWORD * 0x0012C35C (2) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x0293D550 SWORD 2 SWORD * 0x0012C35C MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x0293D550 (2) SWORD 2 SWORD * 0x0012C35C (2) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x0293D552 SWORD 2 SWORD * 0x0012C35C MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x0293D552 (2) SWORD 2 SWORD * 0x0012C35C (2) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x0012C790 SWORD 2 SWORD * 0x0012C776 MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x0012C790 (0) SWORD 2 SWORD * 0x0012C776 (2) MSACCESS 75c-1f0 ENTER SQLAllocStmt HDBC 079F15E8 HSTMT * 0012C354 MSACCESS 75c-1f0 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS) HDBC 079F15E8 HSTMT * 0x0012C354 ( 0x079f18d8) MSACCESS 75c-1f0 ENTER SQLGetStmtOption HSTMT 079F18D8 UWORD 0 PTR 0x0012C300 MSACCESS 75c-1f0 EXIT SQLGetStmtOption with return code 0 (SQL_SUCCESS) HSTMT 079F18D8 UWORD 0 PTR 0x0012C300 MSACCESS 75c-1f0 ENTER SQLSetStmtOption HSTMT 079F18D8 UWORD 0 <SQL_QUERY_TIMEOUT> SQLPOINTER 0x0000003C MSACCESS 75c-1f0 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS) HSTMT 079F18D8 UWORD 0 <SQL_QUERY_TIMEOUT> SQLPOINTER 0x0000003C (BADMEM) MSACCESS 75c-1f0 ENTER SQLExecDirectW HSTMT 079F18D8 WCHAR * 0x1B074AA0 [ -3] "SELECT Config, nValue FROM MSysConf\ 0" SDWORD -3 MSACCESS 75c-1f0 EXIT SQLExecDirectW with return code -1 (SQL_ERROR) HSTMT 079F18D8 WCHAR * 0x1B074AA0 [ -3] "SELECT Config, nValue FROM MSysConf\ 0" SDWORD -3 DIAG [S0002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'database01.msysconf' doesn't exist (1146) MSACCESS 75c-1f0 ENTER SQLErrorW HENV 079F1540 HDBC 079F15E8 HSTMT 079F18D8 WCHAR * 0x0012C294 (NYI) SDWORD * 0x0012C2E0 WCHAR * 0x02941528 SWORD 4095 SWORD * 0x0012C2CC MSACCESS 75c-1f0 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV 079F1540 HDBC 079F15E8 HSTMT 079F18D8 WCHAR * 0x0012C294 (NYI) SDWORD * 0x0012C2E0 (1146) WCHAR * 0x02941528 [ 94] "[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table 'database01.msysconf' doesn't exist" SWORD 4095 SWORD * 0x0012C2CC (94) MSACCESS 75c-1f0 ENTER SQLErrorW HENV 079F1540 HDBC 079F15E8 HSTMT 079F18D8 WCHAR * 0x0012C294 (NYI) SDWORD * 0x0012C2E0 WCHAR * 0x029415FC SWORD 3989 SWORD * 0x0012C2CC MSACCESS 75c-1f0 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND) HENV 079F1540 HDBC 079F15E8 HSTMT 079F18D8 WCHAR * 0x0012C294 (NYI) SDWORD * 0x0012C2E0 WCHAR * 0x029415FC SWORD 3989 SWORD * 0x0012C2CC MSACCESS 75c-1f0 ENTER SQLFreeStmt HSTMT 079F18D8 UWORD 1 <SQL_DROP> MSACCESS 75c-1f0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 079F18D8 UWORD 1 <SQL_DROP> MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 17 <SQL_DBMS_NAME> PTR 0x0012C790 SWORD 200 SWORD * 0x0012C85A MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 17 <SQL_DBMS_NAME> PTR 0x0012C790 [ 10] "MySQL" SWORD 200 SWORD * 0x0012C85A (10) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 0 <SQL_ACTIVE_CONNECTIONS> PTR 0x0012C89E SWORD 2 SWORD * 0x0012C8AC MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 0 <SQL_ACTIVE_CONNECTIONS> PTR 0x0012C89E (0) SWORD 2 SWORD * 0x0012C8AC (4) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x0012C884 SWORD 20 SWORD * 0x0012C8AC MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x0012C884 [ 2] "N" SWORD 20 SWORD * 0x0012C8AC (2) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x0012C89C SWORD 2 SWORD * 0x0012C86C MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x0012C89C (2) SWORD 2 SWORD * 0x0012C86C (2) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x0012C898 SWORD 2 SWORD * 0x0012C86C MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x0012C898 (2) SWORD 2 SWORD * 0x0012C86C (2) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x0012C89A SWORD 2 SWORD * 0x0012C86C MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x0012C89A (2) SWORD 2 SWORD * 0x0012C86C (2) MSACCESS 75c-1f0 ENTER SQLGetInfoW HDBC 079F15E8 UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR> PTR 0x0012C884 SWORD 20 SWORD * 0x0012C8AC MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 079F15E8 UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR> PTR 0x0012C884 [ 2] "`" SWORD 20 SWORD * 0x0012C8AC (2) -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]