Posted by: IvanHoe25852 <ivanho...@interlap.com.ar>
If anybody has connected CTD2K with MySQL trough ODBC or native
connection, please could post it?
Posted by: kdre...@boerner-web.de (Klaus-Dieter Remmler)
yes it is possible to connect to mySQL with CTD via ODBC.
The used system:
- computer with Win2K or NT4 (SP6a)
- mySQL version 3.23.41 (NT)
- mySQL-ODBC driver version 2.50.37.00
- CTD 1.1 or higher (tested 1.1, 1.5 and 2.1)
Register your ODBC source (our name was mySQLDB). All check boxes
leave unchecked and provide host adress, user name, password, database
name and port (3306).
Check your sql.ini section:
The remotedbname must be unique in your sql.ini and no longer than 8
In your client section:
sqlodb32 is the communication dll for ODBC. You can have more
Now try to connect with SQLTalk: database name=MYSQL, user name and
password of your mySQL database and it should work. If you can connect
with SQLTalk you should be able to connect to mySQL with your app.
I tried some SELECTs and INSERTs and it works.
Hope it helps.
Dr. Klaus-Dieter Remmler
- Posts: 5
- Joined: 27 Mar 2019, 08:18
- Location: Berlin
Posted by: toma...@netscape.net (Tom Seichter)
I did it with ODBC, but it doesn't work so fine.
Activate ODBC support, configure MySqlODBC driver (I used V. 3.51),
then edit Sql.ini.
Locate the odbcrtr-section, add the line:
Hope it helps
Who is online
Users browsing this forum: [Ccbot] and 0 guests