Configuring ODBC connection for MYSQL database

prashanto_dev · Post by **prashanto_dev** » Mon Jul 28, 2008 1:10 pm

I have configured the odbc.ini to connect to mysql database ,but when I am trying to import table definition it is not connecting and also breaking the datastage client connection.

I am using the following entry in the odbc.ini. Is it correct for MYSQL

[mysqldsn]
Driver=/d01/Ascential/DataStage/branded_odbc/lib/branded_odbc/lib/VMmysql23.so
Description=MySQL ODBC 3.51 Driver DSN
SERVER=65.91.255.2
Database=edw1kn
PORT=3306
USER=guest
Password=welcome1
OPTION=3
SOCKET=

prashanto_dev · Post by **prashanto_dev** » Tue Jul 29, 2008 3:19 pm

I am getting the error:

Error calling subroutine: DSR_IMPORT (Action=2); check DataStage is set up correctly in project BUIEDW01
(The connection is broken (81002))

srimitta · Post by **srimitta** » Tue Jul 29, 2008 3:27 pm

Did you create entry in uvodbc.config

<mysqldsn>
DBMSTYPE = ODBC

prashanto_dev · Post by **prashanto_dev** » Tue Jul 29, 2008 3:28 pm

yes I have created.

srimitta · Post by **srimitta** » Tue Jul 29, 2008 3:44 pm

Check VMmysql23.so odbc driver in
/d01/Ascential/DataStage/branded_odbc/lib/branded_odbc/lib

prashanto_dev · Post by **prashanto_dev** » Tue Jul 29, 2008 4:18 pm

I have tried other drive also but it is not working

srimitta · Post by **srimitta** » Tue Jul 29, 2008 4:28 pm

mysqldsn]
Driver=/d01/Ascential/DataStage/branded_odbc/lib/branded_odbc/lib/VMmysql23.so
Description=MySQL ODBC 3.51 Driver DSN
SERVER=65.91.255.2
Database=edw1kn
PORT=3306
USER=guest
Password=welcome1
OPTION=3
SOCKET=

check the odbc drivers library path it seems you have entered twice

It supposed to be d01/Ascential/DataStage/branded_odbc/lib/

prashanto_dev · Post by **prashanto_dev** » Tue Jul 29, 2008 4:32 pm

I am using this now:

[mysqldsn]
Driver = /usr/local/mysql/lib/libmyodbc5.so
Description = Connector/ODBC 3.51 Driver DSN
SERVER = 32.91.255.12
PORT = 3306
USER = myuser
Password =
Database = mysqldb1
OPTION = 3
SOCKET =

Still not working