mysql odbc

mysql odbc

am 11.01.2007 07:41:30 von Ritchie DeComa

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

MSACCESS 75c-1f0 EXIT SQLSetConnectOption with return code 0
(SQL_SUCCESS)
HDBC 079F15E8
SQLINTEGER 103
SQLPOINTER 0x00000014 (BADMEM)

MSACCESS 75c-1f0 ENTER SQLSetConnectAttrW
SQLHDBC 079F15E8
SQLINTEGER 30002
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3

MSACCESS 75c-1f0 EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 079F15E8
SQLINTEGER 30002
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

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

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 9
PTR 0x0012C8B0
SWORD 2
SWORD * 0x0012C8A8

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 9
PTR 0x0012C8B0 (1)
SWORD 2
SWORD * 0x0012C8A8 (2)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 6
PTR 0x0012C7C0
SWORD 200
SWORD * 0x0012C8A8

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 6
PTR 0x0012C7C0 [ 26] "libmyodbc3.so"
SWORD 200
SWORD * 0x0012C8A8 (26)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 46
PTR 0x0012C78A
SWORD 2
SWORD * 0x0012C35C

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 46
PTR 0x0012C78A (2)
SWORD 2
SWORD * 0x0012C35C (2)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 23
PTR 0x0293D550
SWORD 2
SWORD * 0x0012C35C

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 23
PTR 0x0293D550 (2)
SWORD 2
SWORD * 0x0012C35C (2)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 24
PTR 0x0293D552
SWORD 2
SWORD * 0x0012C35C

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 24
PTR 0x0293D552 (2)
SWORD 2
SWORD * 0x0012C35C (2)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 1
PTR 0x0012C790
SWORD 2
SWORD * 0x0012C776

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 1
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
SQLPOINTER 0x0000003C

MSACCESS 75c-1f0 EXIT SQLSetStmtOption with return code 0
(SQL_SUCCESS)
HSTMT 079F18D8
UWORD 0
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

MSACCESS 75c-1f0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 079F18D8
UWORD 1

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 17
PTR 0x0012C790
SWORD 200
SWORD * 0x0012C85A

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 17
PTR 0x0012C790 [ 10] "MySQL"
SWORD 200
SWORD * 0x0012C85A (10)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 0
PTR 0x0012C89E
SWORD 2
SWORD * 0x0012C8AC

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 0
PTR 0x0012C89E (0)
SWORD 2
SWORD * 0x0012C8AC (4)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 25
PTR 0x0012C884
SWORD 20
SWORD * 0x0012C8AC

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 25
PTR 0x0012C884 [ 2] "N"
SWORD 20
SWORD * 0x0012C8AC (2)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 46
PTR 0x0012C89C
SWORD 2
SWORD * 0x0012C86C

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 46
PTR 0x0012C89C (2)
SWORD 2
SWORD * 0x0012C86C (2)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 23
PTR 0x0012C898
SWORD 2
SWORD * 0x0012C86C

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 23
PTR 0x0012C898 (2)
SWORD 2
SWORD * 0x0012C86C (2)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 24
PTR 0x0012C89A
SWORD 2
SWORD * 0x0012C86C

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 24
PTR 0x0012C89A (2)
SWORD 2
SWORD * 0x0012C86C (2)

MSACCESS 75c-1f0 ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 29
PTR 0x0012C884
SWORD 20
SWORD * 0x0012C8AC

MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 29
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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: mysql odbc

am 12.01.2007 12:35:45 von Imran Abizar

Ritchie,

I don't see any calls to SQLTable() function, which is supposed to fetch
a list of tables. Instead, I see a SQL query (select * from MSysConf)
that is returning an error.

Try using a third party tool like WinSQL (http://synametrics.com/winsql)
to see if your connection to the database is successful.

Regards,
Imran.


Ritchie DeComa wrote:
> 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
> SQLPOINTER 0x00000014
>
> MSACCESS 75c-1f0 EXIT SQLSetConnectOption with return code 0
> (SQL_SUCCESS)
> HDBC 079F15E8
> SQLINTEGER 103
> SQLPOINTER 0x00000014 (BADMEM)
>
> MSACCESS 75c-1f0 ENTER SQLSetConnectAttrW
> SQLHDBC 079F15E8
> SQLINTEGER 30002
> SQLPOINTER [Unknown attribute 30002]
> SQLINTEGER -3
>
> MSACCESS 75c-1f0 EXIT SQLSetConnectAttrW with return code 0
> (SQL_SUCCESS)
> SQLHDBC 079F15E8
> SQLINTEGER 30002
> 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
>
> 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
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 9
> PTR 0x0012C8B0
> SWORD 2
> SWORD * 0x0012C8A8
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 9
> PTR 0x0012C8B0 (1)
> SWORD 2
> SWORD * 0x0012C8A8 (2)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 6
> PTR 0x0012C7C0
> SWORD 200
> SWORD * 0x0012C8A8
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 6
> PTR 0x0012C7C0 [ 26] "libmyodbc3.so"
> SWORD 200
> SWORD * 0x0012C8A8 (26)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 46
> PTR 0x0012C78A
> SWORD 2
> SWORD * 0x0012C35C
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 46
> PTR 0x0012C78A (2)
> SWORD 2
> SWORD * 0x0012C35C (2)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 23
> PTR 0x0293D550
> SWORD 2
> SWORD * 0x0012C35C
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 23
> PTR 0x0293D550 (2)
> SWORD 2
> SWORD * 0x0012C35C (2)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 24
> PTR 0x0293D552
> SWORD 2
> SWORD * 0x0012C35C
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 24
> PTR 0x0293D552 (2)
> SWORD 2
> SWORD * 0x0012C35C (2)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 1
> PTR 0x0012C790
> SWORD 2
> SWORD * 0x0012C776
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 1
> 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
> SQLPOINTER 0x0000003C
>
> MSACCESS 75c-1f0 EXIT SQLSetStmtOption with return code 0
> (SQL_SUCCESS)
> HSTMT 079F18D8
> UWORD 0
> 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
>
> MSACCESS 75c-1f0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
> HSTMT 079F18D8
> UWORD 1
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 17
> PTR 0x0012C790
> SWORD 200
> SWORD * 0x0012C85A
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 17
> PTR 0x0012C790 [ 10] "MySQL"
> SWORD 200
> SWORD * 0x0012C85A (10)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 0
> PTR 0x0012C89E
> SWORD 2
> SWORD * 0x0012C8AC
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 0
> PTR 0x0012C89E (0)
> SWORD 2
> SWORD * 0x0012C8AC (4)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 25
> PTR 0x0012C884
> SWORD 20
> SWORD * 0x0012C8AC
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 25
> PTR 0x0012C884 [ 2] "N"
> SWORD 20
> SWORD * 0x0012C8AC (2)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 46
> PTR 0x0012C89C
> SWORD 2
> SWORD * 0x0012C86C
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 46
> PTR 0x0012C89C (2)
> SWORD 2
> SWORD * 0x0012C86C (2)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 23
> PTR 0x0012C898
> SWORD 2
> SWORD * 0x0012C86C
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 23
> PTR 0x0012C898 (2)
> SWORD 2
> SWORD * 0x0012C86C (2)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 24
> PTR 0x0012C89A
> SWORD 2
> SWORD * 0x0012C86C
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 24
> PTR 0x0012C89A (2)
> SWORD 2
> SWORD * 0x0012C86C (2)
>
> MSACCESS 75c-1f0 ENTER SQLGetInfoW
> HDBC 079F15E8
> UWORD 29
> PTR 0x0012C884
> SWORD 20
> SWORD * 0x0012C8AC
>
> MSACCESS 75c-1f0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
> HDBC 079F15E8
> UWORD 29
> 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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: mysql odbc

am 12.01.2007 13:03:29 von Martin Evans

Imran Abizar wrote:
> Ritchie,
>
> I don't see any calls to SQLTable() function, which is supposed to fetch
> a list of tables. Instead, I see a SQL query (select * from MSysConf)
> that is returning an error.

MS Access always does this. It is because if you create msysconf
table you can put ms access settings in it. The jet whitepaper
describes it.


> Try using a third party tool like WinSQL (http://synametrics.com/winsql)
> to see if your connection to the database is successful.
>
> Regards,
> Imran.
>
>
> Ritchie DeComa wrote:
>> 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:
>>



Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: mysql odbc

am 12.01.2007 13:04:55 von Imran Abizar

Martin,

This is good to know. Could you please send me link for the Jet
Whitepaper, I'd like to learn what else Access does in the background.

Thanks,
Imran.

Martin Evans wrote:
> Imran Abizar wrote:
>> Ritchie,
>>
>> I don't see any calls to SQLTable() function, which is supposed to
>> fetch a list of tables. Instead, I see a SQL query (select * from
>> MSysConf) that is returning an error.
>
> MS Access always does this. It is because if you create msysconf
> table you can put ms access settings in it. The jet whitepaper
> describes it.
>
>
>> Try using a third party tool like WinSQL
>> (http://synametrics.com/winsql) to see if your connection to the
>> database is successful.
>>
>> Regards,
>> Imran.
>>
>>
>> Ritchie DeComa wrote:
>>> 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:
>>>
>
>
>
> Martin

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: mysql odbc

am 12.01.2007 14:13:07 von Martin Evans

Imran Abizar wrote:
> Martin,
>
> This is good to know. Could you please send me link for the Jet
> Whitepaper, I'd like to learn what else Access does in the background.
>
> Thanks,
> Imran.

Sorry, no, I cannot find it any more but I can send you an HTML copy
privately if you'd like.

Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com

> Martin Evans wrote:
>> Imran Abizar wrote:
>>> Ritchie,
>>>
>>> I don't see any calls to SQLTable() function, which is supposed to
>>> fetch a list of tables. Instead, I see a SQL query (select * from
>>> MSysConf) that is returning an error.
>>
>> MS Access always does this. It is because if you create msysconf
>> table you can put ms access settings in it. The jet whitepaper
>> describes it.
>>
>>
>>> Try using a third party tool like WinSQL
>>> (http://synametrics.com/winsql) to see if your connection to the
>>> database is successful.
>>>
>>> Regards,
>>> Imran.
>>>
>>>
>>> Ritchie DeComa wrote:
>>>> 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

--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
>>>> 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:
>>>>
>>
>>
>>
>> Martin
>
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org