Hi Kusnardi,

If you don't specify user [and password] then login failed.
I don't know why ADO, across ODBC API, don't call dialog for login.

MartinJ

>Hi,
>
>I tried to connect vfp to mysql using the following code:
>
>

>Connection = CREATEOBJECT("ADODB.Connection")
>lcConnString = "DRIVER={MySQL ODBC 3.51 Driver};" +;
>      "Server=localhost;port=3306;option=;stmt=;" + ;
>      "Database=msg;uid=;pwd=;"
>oConnection.OPEN(lcConnString)
>

>
>And it get error message.
>
>Does anyone know how to connect to mysql? thanks for your help.
>
>regards,
>Kusnardi