Unable to link Microsoft Access with MYSQL
Tom Reilly <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
I've been using microsoft access with mysql for several years without
any trouble,
that is until I downloaded the latest version of mysql.
I've no problem accessing mysql using ruby, or visual basic. However, I
am no longer
able to link mysql tables using MS Access. There is no problem with the
creation of a
new machine data source which can be accessed by the ODBC Driver. When
I try to link
a database nothing happens -- no messages, no nothing.
I am using MYSQL ODBC Driver 3.51
Microsoft Access 2000 (9.0.2720)
Operating System Windows 2000 Service Pack 4.
MYSQL Server 5.0 Ver 14.12 Distrib 5.0.22 for Win32
I've installed the latest version of Microsoft Jet.
The following is the log file created when trying to link access to mysql.
I'd appreciate if if anyone could tell me what I'm missing.
----------------------------
LOG FILE WHEN TRYING TO LINK VIA ODBC:
MSACCESS 678-79c ENTER SQLAllocConnect
HENV 07E91540
HDBC * 0012C88C
MSACCESS 678-79c EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 07E91540
HDBC * 0x0012C88C ( 0x07e92490)
MSACCESS 678-79c ENTER SQLSetConnectOption
HDBC 07E92490
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014
MSACCESS 678-79c EXIT SQLSetConnectOption with return code 0
(SQL_SUCCESS)
HDBC 07E92490
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014 (BADMEM)
MSACCESS 678-79c ENTER SQLSetConnectAttrW
SQLHDBC 07E92490
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
MSACCESS 678-79c EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 07E92490
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
MSACCESS 678-79c ENTER SQLDriverConnectW
HDBC 07E92490
HWND 00BA065A
WCHAR * 0x1F7C48DC [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C48DC
SWORD 8
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>
MSACCESS 678-79c EXIT SQLDriverConnectW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
HWND 00BA065A
WCHAR * 0x1F7C48DC [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C48DC
SWORD 8
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 9 <SQL_ODBC_API_CONFORMANCE>
PTR 0x0012C8B0
SWORD 2
SWORD * 0x0012C8A8
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 9 <SQL_ODBC_API_CONFORMANCE>
PTR 0x0012C8B0 (1)
SWORD 2
SWORD * 0x0012C8A8 (2)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012C7C0
SWORD 200
SWORD * 0x0012C8A8
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012C7C0 [ 26] "libmyodbc3.so"
SWORD 200
SWORD * 0x0012C8A8 (26)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012C78A
SWORD 2
SWORD * 0x0012C35C
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012C78A (2)
SWORD 2
SWORD * 0x0012C35C (2)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0343DA68
SWORD 2
SWORD * 0x0012C35C
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0343DA68 (2)
SWORD 2
SWORD * 0x0012C35C (2)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0343DA6A
SWORD 2
SWORD * 0x0012C35C
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0343DA6A (2)
SWORD 2
SWORD * 0x0012C35C (2)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x0012C790
SWORD 2
SWORD * 0x0012C776
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x0012C790 (0)
SWORD 2
SWORD * 0x0012C776 (2)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 17 <SQL_DBMS_NAME>
PTR 0x0012C790
SWORD 200
SWORD * 0x0012C85A
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 17 <SQL_DBMS_NAME>
PTR 0x0012C790 [ 10] "MySQL"
SWORD 200
SWORD * 0x0012C85A (10)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 0 <SQL_ACTIVE_CONNECTIONS>
PTR 0x0012C89E
SWORD 2
SWORD * 0x0012C8AC
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 0 <SQL_ACTIVE_CONNECTIONS>
PTR 0x0012C89E (0)
SWORD 2
SWORD * 0x0012C8AC (4)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 25 <SQL_DATA_SOURCE_READ_ONLY>
PTR 0x0012C884
SWORD 20
SWORD * 0x0012C8AC
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 25 <SQL_DATA_SOURCE_READ_ONLY>
PTR 0x0012C884 [ 2] "N"
SWORD 20
SWORD * 0x0012C8AC (2)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012C89C
SWORD 2
SWORD * 0x0012C86C
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012C89C (2)
SWORD 2
SWORD * 0x0012C86C (2)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0012C898
SWORD 2
SWORD * 0x0012C86C
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0012C898 (2)
SWORD 2
SWORD * 0x0012C86C (2)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0012C89A
SWORD 2
SWORD * 0x0012C86C
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0012C89A (2)
SWORD 2
SWORD * 0x0012C86C (2)
MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
PTR 0x0012C884
SWORD 20
SWORD * 0x0012C8AC
MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
PTR 0x0012C884 [ 2] "`"
SWORD 20
SWORD * 0x0012C8AC (2)
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/[email protected]