View Designer & MySql ODBC problem

[Jean]

I need to connect to a table in MySql through ODBC driver

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

es
userlogin : misterx
database: PIPPO
table PLUTO (pippo.pluto)

- I open the designer
- I connect to the server (ok)
- I connect to the db (ok)
- I see all tables of the db
-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"

The Disigner replace the name of the db with the name of the user

Is that a VFP bug ???
Any solution ???

thanks

[Dummy Newgroup name]

I've had something like this.
I'm rather busy for the next few days, and am desparately trying to
remember what it was.
I think it was that there's a checkbox somewhere (connection?) about
"remote view", which I remember ranting on about being as sensible as
the "SQL update" on the VFP view (?) dialog. If you don't find it
I'll have a look again, but it'll be a few days.

Mark Stanton
One small step for mankind...

[Jean]

No, I can't find any solution
tested all checkbox
help!!

Post by Dummy Newgroup name
I've had something like this.
I'm rather busy for the next few days, and am desparately trying to
remember what it was.
I think it was that there's a checkbox somewhere (connection?) about
"remote view", which I remember ranting on about being as sensible as
the "SQL update" on the VFP view (?) dialog. If you don't find it
I'll have a look again, but it'll be a few days.
Mark Stanton
One small step for mankind...

[Mark Stanton]

OK, here's what I know.

Here in this very newsgroup (it seems to have gone from my
messagebase so I can't quote) I got told that on the "add table"
dialog there's a checkbox called something like "all user tables",
which actually means "allow user tables", which is stupid (IMNVHO)
because without checking it you can't add anything.

Someone else (on Ed Leafe's messageboard at www.leafe.com, the one on
VFP/MySQL connectivity) suggested that I check the connection options
might be strangely set which, whilst it appeared to be true, didn't
make the difference (I think).

Someone else there said

"When you create the mySQL connection in the DBC, you have to
give it the same name as the mySQL database you want to
access."

which might be another factor?

Regards
Mark Stanton
One small step for mankind...