Riley,

>This causes VFP8 and VFP9 to crash with a Fatal Execption Error.

Or VFP to be recieving the C05 from some problem in the MySQL ODBC driver...

I don't use MySQL so I'm not sure what issues there may be with it. You might want to start a specific thread about it and maybe some of he other MySQL users can give you some more help.

I use ODBC to SQL Server and Sybase quite extensively from VFP without C05 crashes.

>lcdsnless =;
> "DRIVER={MySQL ODBC 3.51 Driver};" +;
> "SERVER=" + '192.168.1.100' + ";" +;
> "UID=" + 'rileys' + ";" +;
> "PASSWORD=" + 'bingo'+ ";" +;
> "DB=" + 'test' + ";" +;
> "PORT=3306;" +;
> "SOCKET=;" +;
> "OPTION=" + TRANSFORM(1+4+8+64+512+1024+2048+16384+524288) + ";" +;
> "STMT;"
>wait lcdsnless window
>gn=SQLSTRINGCONNECT(lcDSNLess)
>IF gn > 0
> WAIT 'OK!'
> cancel
> ? SQLTABLES(lnHandle,"TABLES")
> browse last nocaptions
> SQLDISCONNECT(lnHandle)
>ELSE
> =AERROR(laError)
> MESSAGEBOX("Error at Connecting"+CHR(13)+;
> "Description:"+laError[2])
>ENDIF
>
>The wait executes to confirm my settings and then when sqlstringconnect executes VFP halts.
>I tried using gn=sqlconnect('mysql','rileys','bingo') and I get "Could not determine the driver so could not lookup the setup library" in the odbc error string.
>When I test the connection using the ODBC admin in XP it tests fine and I can connect to the database using mysql browser so I think my connection to the server and database is not the issue.