MySql

[Jack]

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

[anserkk]

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;"

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

[Jack]

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

[anserkk]

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

[Jack]

Thanks