Re: mysql odbc
Martin Evans <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
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: >>>> >> >> <snipped trace> >> >> Martin > > -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]