Hi Mark
Thats true, they are case sensitive, but you can by pass that using "lower_case_table_names=1" in "my.cnf", the configuration file of MySQL.
Just add that parameter to my.cnf , restart MySQL and.... voilá :)


>Hi Mark,
>
>If the MySQL server run on UNIX/LINUX, the name of objects are case sensitive.
>
>MartinaJ
>
>>I'm using FoxPro. On the MySQL at my office that I control I can connect via ODBC, query the tables and insert new records.
>>
>>At my client with MySQL, from my compiled VFP app, I get a successful connection via ODBC to the VOX database, but every attempt to access a table eg "select * from Vox_Projects" I get an error "..Table vox.vox_projects not found.
>>
>>I'm on a machine that accesses and updates this table in the VOX database thru Access.
>>
>>I don't have the MySQL command program on the computer I'm on at the client's office. The programmer who set it up is in NY and says it was years ago, so is not a big help.
>>
>>Could this be a privileges issue? Can they hide the tables from a different program? Is there a SQL command I could execute in my compiled program to test for it?
>>
>>Or do I need to get access to their computer with the MySQL command program to see and change the privileges?
>>
>>Or can I download the free MySQL onto the machine I use there and run the MySQL command line and change from there?
>>