Connectivity error:[MySQL][ODBC ....

[Jean]

I got a strange behavior, I need to connect to a table in MySql through ODBC
driver

No problem to create the connection, when i try to create a remote view I
got an error when I try to add any tables of the db and the error is that
VFP switch the name of the database with the name of the user

user: misterx
database: PIPPO table PLUTO (pippo.pluto)

in the view designer when I try to add some table to the designer I got this
error

"Connectivity error:[MySQL][ODBC 3.51 Driver][mysqld-4.0.18-log] Table
'misterx.pluto' doesn't exist"

Is that a VFP bug ???

[Stefan Wuebbe]

If this helps
http://groups.google.com/groups?selm=%23u9lqBj1DHA.2700%40TK2MSFTNGP11.phx.gbl
it's a MySQL / MyODBC driver issue, I think.

hth
-Stefan

Post by Jean
I got a strange behavior, I need to connect to a table in MySql through ODBC
driver
No problem to create the connection, when i try to create a remote view I
got an error when I try to add any tables of the db and the error is that
VFP switch the name of the database with the name of the user
user: misterx
database: PIPPO table PLUTO (pippo.pluto)
in the view designer when I try to add some table to the designer I got this
error
"Connectivity error:[MySQL][ODBC 3.51 Driver][mysqld-4.0.18-log] Table
'misterx.pluto' doesn't exist"
Is that a VFP bug ???