How To Connect MySQL Databases

General discussion forum about all databases other than SqlBase.
Sunil

How To Connect MySQL Databases

Post by Sunil » 04 Mar 2014, 03:56

Hi All,

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

Regards.
Sunil

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 3231
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

Re: How To Connect MySQL Databases

Post by Dave Rabelink » 04 Mar 2014, 22:11

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.
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

Sunil

Re: How To Connect MySQL Databases

Post by Sunil » 05 Mar 2014, 04:38

Thanks Dave.

Regards.
Sunil

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot], [Google] and 0 guests