Re: mysql odbc
Martin Evans <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
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: >> <snipped trace> 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/[email protected]