Sys-Admin Information’s

Share Knowledge, Distribute Knowledge, Capture & Modify Knowledge, Create Knowledge

Author Archive

Oracle Heterogeneous Configuration Service (ORACLE to MySQL)

with 2 comments

PART I : Setting up ODBC driver

1. Install mysql-connector-odbc-3.51.12-linux-i686.rpm

bash> rpm –ivh mysql-connector-odbc-3.51.12-linux-i686.rpm

2. Start Mysql Daemon

bash> /etc/init.d/mysqld start
Initializing MySQL database:                               [  OK  ]

3. Configure ODBC

bash> ODBCConfig

4. Modify : /etc/odbc.ini

bash> vi /etc/odbc.ini
[trans]
Driver                             = MySQL ODBC 3.51 Driver
DATABASE                    = kampus
DESCRIPTION             = punya_kampus
PWD                                = password
PORT                              = 3306
SERVER                         = localhost
UID                                 = root

Read the rest of this entry »

Written by Henri Simatupang

March 5th, 2008 at 1:55 pm

Posted in Mysql, ODBC, Oracle

Tagged with