How To Connect MySQL Databases

[Sunil]

Hi All,

can anyone help me How to connect MySQL Databases using Gupta Products.

Regards.
Sunil

[Dave Rabelink]

Use an sql.ini like this:

Code: Select all

[win32client]
clientname=tstmysql
clientruntimedir="C:\Program Files (x86)\Unify\Team Developer 6.1"

[win32client.dll]
comdll=sqlodb32

[odbcrtr]
odbctrace=off
odbctracefile=sql.log
remotedbname=MySQL, DSN=MySQL

- Install MySql
- Install MySql ODBC driver
- Setup datasources in windows for ODBC, add MySql
- Use sql.ini, setup the correct DSN you have provided in the windows ODBC setup

In TD, set SqlDatabase, password and user and do SqlConnect.

I have also used MariaDB (a fork of MySql) which works the same.

[Sunil]

Thanks Dave.

Regards.
Sunil