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.
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]) ENDIFI 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.