Help needed to create link between Oracle and MySQL database

[Narasimham Gudimella]

Hi all,

I have a Oracle 11G db running on Linux server(64bit) .
My target is to automate data extraction process from MySql databases from different server. So I wanted to create a link between MySql and Oracle bases (similar to dblink for oracle databases)
To connect these two databases, I have installed mysql-connector-odbc-5.3.4.

When I try to verify the connection by running this command isql -v MyDB dbuser user123 ; I am getting an error as below

[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

I need help with configuring ODBC on Linux and creating dblink


Below is the output for odbcinst -q -d
[MyDB]
[MySQL ODBC 5.3 Unicode Driver]
[MySQL ODBC 5.3 ANSI Driver]


Path for .ini files are as below :
/etc/odbc.ini
/etc/odbcinst.ini

This is how my /etc/odbc.ini looks like :
[MyDB]
description = MS SQL connection to 'MyDB' database
#Driver64 = MySQL ODBC 5.3 Driver
Driver64 = MySQL ODBC 5.3 Unicode Driver
Database = mydatabase
Server = servername.com
UserName = dbuser
Password = user123
Port = xxxx

This is how my /etc/odbcinst.ini looks like :

[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbc.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1

[MySQL ODBC 5.3 Unicode Driver]
Driver = /usr/lib64/libmyodbc5w.so
UsageCount = 1

[MySQL ODBC 5.3 ANSI Driver]
Driver = /usr/lib64/libmyodbc5a.so
UsageCount = 1



Thanks in advance for you help
NG