ODBC 3.51.22 not working with Systat
"Gary Lewis" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Hi - I downloaded and installed mysql-connector-odbc-3.51.22-win32.msi. The OS is MS Windows XP Professional Version 2002 SP2. The installation completed successfully. I used ODBC Data Source Administrator to create and successfully test a DSN using the MySQL ODBC 3.51 driver. What doesn't work is Systat (v 12.01.02) when I try to access a MySQL database table via ODBC. It sees the Data Source I created, but it does not list the database (ie, schema) or any tables. These are grayed out and just hung. Here's the last bit of the sql.log trace file: SYSTAT c40-f60 ENTER SQLGetData HSTMT 05082B88 UWORD 12 SWORD 1 <SQL_C_CHAR> PTR 0x0012C18C SQLLEN 128 SQLLEN * 0x0012C20C SYSTAT c40-f60 EXIT SQLGetData with return code 0 (SQL_SUCCESS) HSTMT 05082B88 UWORD 12 SWORD 1 <SQL_C_CHAR> PTR 0x0012C18C SQLLEN 128 SQLLEN * 0x0012C20C (0) SYSTAT c40-f60 ENTER SQLFetch HSTMT 05082B88 SYSTAT c40-f60 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND) HSTMT 05082B88 SYSTAT c40-f60 ENTER SQLFreeStmt HSTMT 05082B88 UWORD 1 <SQL_DROP> SYSTAT c40-f60 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS) HSTMT 05082B88 UWORD 1 <SQL_DROP> And the myodbc.log file: -- Query logging -- -- Driver name: MySQL ODBC 3.51 Driver Version: 03.51.22 -- Timestamp: 071129 11:24:18 SHOW TABLE STATUS ; SHOW TABLE STATUS LIKE 't1'; What I'd like to figure out is if this is a MySQL ODBC Connector problem or a Systat problem. I'm using a 30-day trial version of Systat, but it's supposed to be a fully functional version. Any help would be appreciated. Thanks. Gary