Re: mysql odbc

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:
>>>
>
> <snipped trace>
>
> Martin

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]