LOCAL lihdbc,lcCS
* if you uses driver MySQL (version 2.5x)
=SQLSETPROP(0,"DispLogin",3)
lcCS="driver={MySQL};DB=database_name;SERVER=localhost;"+;
     "PORT=3306;OPTION=131073;STMT=;"+;
     "UID=UserID;PWD=Password;"
lihdbc=SQLSTRINGCONNECT(lcCS)


* if you uses driver MySQL ODBC 3.51 Driver
lcCS="driver={MySQL ODBC 3.51 Driver};DB=database_name;SERVER=localhost;"+;
     "PORT=3306;OPTION=131073;STMT=;"+;
     "UID=UserID;PWD=Password;"
lihdbc=SQLSTRINGCONNECT(lcCS)

MartinJ

>Hi all,
>
>Can I connect in MySQL without use ODBC ? If no then how to create a DSN automatically ?
>
>Many thanks
>
>Vinicius Ribeiro