Whenever you get an error result value from any SQL function you should call aerror() and look at the content of the output array to find more detailed information on what is wrong.
A lot of developers wrap these SPT commands with their own functions/methods in order to facilitate the trapping of these errors and handling them.
>Hi,
>
>My program as below :-
>
>*****
>CON=SQLSTRINGCONNECT("DRIVE=MYSQL ODBC 3.51 DRIVER;SERVER=localhost;UID=a;PWD=a;DATABASE=a")
>
>IF CON>0
> =MESSAGEBOX("OK")
>ELSE
> =MESSAGEBOX("FAILD")
>ENDIF
>*****
>
>I can not connect MySQL auto, it will prompt me to select the Driver by manually.
>
>Is't something wrong in my command line at "CON=SQLSTRING....."
>
>I am sure that it can connected, if i select by manually.