Take a look at this.
http://groups.yahoo.com/group/VFPMySql/message/11

This will show you how to create a connection string for a mysql server. Which does work.

or

'You can stop this behavior is the define the datasource
in ControlPanel, then to go on it and check the 'Pad char to full
length', 'Don't optimize column width' and 'Safety (check this if you
have problems)'.

Bob Lee

>I've been trying to create remote views from VFP 6.0 sp5 on a couple of tables in MySQL using the MySQL ODBC driver for Win95.
>
>The problem I have is that when you look at the field properties for character fields the largest size I can set is 20 characters even though it is 35 characters in the table. Even Access manages to connect (with the same DSN) and get it right.
>
>Anybody got any ideas what I need to change in VFP to make it work?
>
>Barry