Unable to link Microsoft Access with MYSQL

Unable to link Microsoft Access with MYSQL

am 16.07.2006 02:50:41 von Tom Reilly

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
SQLPOINTER 0x00000014

MSACCESS 678-79c EXIT SQLSetConnectOption with return code 0
(SQL_SUCCESS)
HDBC 07E92490
SQLINTEGER 103
SQLPOINTER 0x00000014 (BADMEM)

MSACCESS 678-79c ENTER SQLSetConnectAttrW
SQLHDBC 07E92490
SQLINTEGER 30002
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3

MSACCESS 678-79c EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 07E92490
SQLINTEGER 30002
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

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

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 9
PTR 0x0012C8B0
SWORD 2
SWORD * 0x0012C8A8

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 9
PTR 0x0012C8B0 (1)
SWORD 2
SWORD * 0x0012C8A8 (2)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 6
PTR 0x0012C7C0
SWORD 200
SWORD * 0x0012C8A8

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 6
PTR 0x0012C7C0 [ 26] "libmyodbc3.so"
SWORD 200
SWORD * 0x0012C8A8 (26)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 46
PTR 0x0012C78A
SWORD 2
SWORD * 0x0012C35C

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 46
PTR 0x0012C78A (2)
SWORD 2
SWORD * 0x0012C35C (2)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 23
PTR 0x0343DA68
SWORD 2
SWORD * 0x0012C35C

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 23
PTR 0x0343DA68 (2)
SWORD 2
SWORD * 0x0012C35C (2)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 24
PTR 0x0343DA6A
SWORD 2
SWORD * 0x0012C35C

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 24
PTR 0x0343DA6A (2)
SWORD 2
SWORD * 0x0012C35C (2)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 1
PTR 0x0012C790
SWORD 2
SWORD * 0x0012C776

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 1
PTR 0x0012C790 (0)
SWORD 2
SWORD * 0x0012C776 (2)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 17
PTR 0x0012C790
SWORD 200
SWORD * 0x0012C85A

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 17
PTR 0x0012C790 [ 10] "MySQL"
SWORD 200
SWORD * 0x0012C85A (10)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 0
PTR 0x0012C89E
SWORD 2
SWORD * 0x0012C8AC

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 0
PTR 0x0012C89E (0)
SWORD 2
SWORD * 0x0012C8AC (4)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 25
PTR 0x0012C884
SWORD 20
SWORD * 0x0012C8AC

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 25
PTR 0x0012C884 [ 2] "N"
SWORD 20
SWORD * 0x0012C8AC (2)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 46
PTR 0x0012C89C
SWORD 2
SWORD * 0x0012C86C

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 46
PTR 0x0012C89C (2)
SWORD 2
SWORD * 0x0012C86C (2)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 23
PTR 0x0012C898
SWORD 2
SWORD * 0x0012C86C

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 23
PTR 0x0012C898 (2)
SWORD 2
SWORD * 0x0012C86C (2)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 24
PTR 0x0012C89A
SWORD 2
SWORD * 0x0012C86C

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 24
PTR 0x0012C89A (2)
SWORD 2
SWORD * 0x0012C86C (2)

MSACCESS 678-79c ENTER SQLGetInfoW
HDBC 07E92490
UWORD 29
PTR 0x0012C884
SWORD 20
SWORD * 0x0012C8AC

MSACCESS 678-79c EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 07E92490
UWORD 29
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/win32?unsub=gcdmw-win32@m.gmane.org