Hi Calvin,

I don't know if it's related to your problem but there seems to be a problem with the latest MySQL ODBC 3.51.10 Driver. Check http://fox.wikis.com/wc.dll?Wiki~MySql~SQL.

>I am attempting to use VFP 7 to connect to a remote MySQL database. Delphi connects in less than 1 second. The ODBC test connection does also. VFP takes 23 to 30 seconds. I am new to this, is this speed normal for VFP? I have attempted this with OLEDB with the same time result. I am using MySQL ODBC 3.51 Driver. Here is my code:

>STORE SQLCONNECT('xxxxxx', 'xxxxx','xxxxx') TO myh
>IF myh < 0
> = MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
>ELSE
>     * to this point takes 23 to 30 seconds.
>   = MESSAGEBOX('Connection made', 48, 'SQL Connect Message')
>   r=SQLTABLES(myh, "TABLE", "mydbresult")
>   if r=1
>    select mydbresult
>    browse
>   else
>    wait 'Not able to read' window
>   endif
>   = SQLDISCONNECT(myh)
>ENDIF