Re: mysql odbc

Imran Abizar <[email protected]>
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <[email protected]> 
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 <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]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.