Hi Esperta,

May be http://dev.mysql.com/doc/mysql/en/Setup-error.html, http://support.microsoft.com/default.aspx?scid=kb;EN-US;q260558

Please, turn on creating trace file on MySQL ODBC - http://dev.mysql.com/doc/mysql/en/MyODBC_trace.html.

Another way is download to version 3.51.09

MartinJ

>Hi to all!!
>
>I'm getting a C05 error using VFP9 and MySQL ODBC Driver 3.51..
>
>In Command Window:
>

>lnHandle = SQLCONNECT("test")
>?AERROR(laError)  && <-- -1
>?laError[2]
>*****************************************
>* LaError[2]
>* Connectivity error: [MySQL][ODBC 3.51 Driver]Could not determine the driver
>* name so could not lookup setup library.
>*****************************************
>

>
>I've test the "test" DataSource and works just fine.
>
>If I run the following code
>

>lcServer="www.espartha.com"
>lcDatabase="esparta"
>lcUser = "root"
>lcPassword = "root"
>lcStringConn="Driver={MySQL ODBC 3.51 Driver};Port=3306"+;
>             ";Server="+lcServer+;
>             ";Database="+lcDatabase+;
>             ";Uid="+lcUser+;
>             ";Pwd="+lcPassWord
>*** No prompt window
>SQLSETPROP(0,"DispLogin",3)
>lnHandle=SQLSTRINGCONNECT(lcStringConn)
>IF lnHandle > 0
>   ?SQLTABLES(lnHandle,"TABLES")
>   brow
>   SQLDISCONNECT(lnHandle)
>ELSE
>   =AERROR(laError)
>   MESSAGEBOX("Error de conexión"+CHR(13)+;
>              "Descripcion:"+laError[2])
>ENDIF
>

>
>I got the the C05 error. VFP9error.log says this:
>

>Fatal error: Exception code=C0000005 @ 01/20/05 08:28:34 PM. Error log file: C:\Archivos de programa\Microsoft Visual FoxPro 9\vfp9err.log
>	Called from -  00005fd5005f line 12  {c:\docume~1\epalma\config~1\temp\00005fd5005f.prg c:\docume~1\epalma\config~1\temp\00005fd5005f.fxp}
>

>
>Firewall are off, direct conection via DialUp.
>Some advices?