FiveTech Software tech support forums

I want to connect to a mysql database .
What is the connection string ?
Should i have to install an ODBC drivers ?

Here is a sample with MS sql :
cConnStr := 'Provider='+cPROVIDER+';Data Source='+cFrom+';Initial Catalog='+cDB+';User Id='+cuser+';Password='+cpsw
oCon := TOLEAuto():New('ADODB.Connection')
oCon:ConnectionString := cConnStr
*

Thanks

Jack wrote:What is the connection string ?

Connection String
ConnectionString := "Driver={MySQL ODBC 3.51 Driver};Server=192.168.0.170;Port=3306;Database=databasename;User=username;Password=password;Option=3;"

Jack wrote:Should i have to install an ODBC drivers ?

You can access MySQL Database via ADO and in this method you require ODBC Driver to be installed on all the client PC's

You can also access MySQL via Mr.Daniel's TDolphin class which does not require the ODBC driver to be installed in client PC's

Hope it is clear to you

Regards
Anser

Does the solution with the ODBC driver work with Win7 32 or 64 bits ?
Thanks

Jack wrote:Does the solution with the ODBC driver work with Win7 32 or 64 bits ?

MySQL ODBC Driver for Windows 32 bit as well as 64 bit is available on the following website
http://dev.mysql.com/downloads/connector/odbc/

Regards
Anser

Thanks