I am using vfp9 in win xp professional sp2, Mysql 5.1, ODBC 3.51.23.
I have been trying to use remote view wizard to create the remote view, connection is success, the wizard show me all the tables in the mysql database, when I select one of the table, the system prompt me a message "Connectivity Error:[MySQL][ODBC 3.51 Driver][mysqld-5.1.23]Table 'user.table' deosn't exist",the connection works fine from inside the code (prg or form) and I select the records from the same table, which means the connection is correct and the tables in the database also OK.
This problem comes only with remote view
Thanks to all
so its a typo...
either you have mispellt the table(s)
or you have included extraneous characters (eg spaces)
or you haver a capitalisation problem
..as you state it works locally then I'd guess its going to be captialisation
MS MySQL is partially case independant, *nix is case dependant