Centura + ODBC

comp.databases.gupta (1995-2015)
IvanHoe25852

Centura + ODBC

Post by IvanHoe25852 » 08 Jun 2003, 04:29

 Posted by:  IvanHoe25852 <ivanho...@interlap.com.ar> 

If anybody has connected CTD2K with MySQL trough ODBC or native
connection, please could post it?

Thanks

Klaus-Dieter Remmler

Centura + ODBC

Post by Klaus-Dieter Remmler » 10 Jun 2003, 15:14

 Posted by:  kdre...@boerner-web.de (Klaus-Dieter Remmler) 

Hallo,

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:
[odbcrtr]
odbctrace=off
odbctracefile=sql.log
buffrow=1
longbuffer=32767
remotedbname=MYSQL,DSN=mySQLDB

The remotedbname must be unique in your sql.ini and no longer than 8
characters.

In your client section:
[win32client.dll]
comdll=sqlodb32

sqlodb32 is the communication dll for ODBC. You can have more
comdll-entries activated.

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.
Regards
Dr. Klaus-Dieter Remmler
from Eisenach

tomancer
Germany
Posts: 5
Joined: 27 Mar 2019, 08:18
Location: Berlin

Centura + ODBC

Post by tomancer » 10 Jun 2003, 17:24

 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:
remotedbname=yourmysqldb,DNS=yourdrivername

Hope it helps

Tom

Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot] and 0 guests