Translate this Page

 

In Oracle DB World, sometime we need an interface to connect From Oracle DB to MySQL DB. Oracle have Heterogenous Service ODBC to help us to do this task. In this posting, I am using Linux Redhat, Oracle DB 10g and MySQL 4. Let’s play :

Part I: Setting up the ODBC driver
———————————-
1. copy file mysql-connector-odbc-3.51.12-1.i586.rpm to Oracle DB server

2. install odbc for mysql.

rpm -i mysql-connector-odbc-3.51.12-1.i586.rpm

3. Edit the file /etc/odbc.ini
Add the Data Source of MySQL DB that we want to connect. I create data source named “trans”.

[ODBC Data Sources]
mysql = MyODBC 3.51 Driver DSN

[trans]
Driver = /usr/lib/libmyodbc3.so
Description = mysql connection to test
SERVER = 172.16.11.213
PORT = 3306
USER = root
Password = password
Database = Transaksi_DB
OPTION = 3
SOCKET =

Continue reading »

© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha