Skip navigation links
Showing entries 1 to 1

Tags Filter: dg4odbc (reset)

Articles
Add to Favourites +1 Vote Up -0Vote Down
The Oracle gateway for ODBC provides an almost seamless data integration between Oracle and other RDBMS. I won't argue about its performance, limits, or relevance. It serves a few purposes; set it up and you'll be able, for example, to create database links between Oracle and MySQL. After all, wouldn't it be nice if you could run some of the following SQL statements? "select o.col1, m.col1 from oracle_tabo, mysql_tab@mysql m where o.col1=m.col1;" "insert into oracle_tab (select * from mysql_tab@mysql);"This post is intended to share, the same way Karun did it for SQL Server last year, some tips related to the setup of the Oracle Gateway for ODBC with MySQL Connector ODBC on Linux.PrerequisitesI've installed all the configuration on my laptop to test it. It's running Ubuntu Intrepid Ibex 32bits, but I won't dig into the challenge of installing the MySQL Connector ODBC 5.1 on it. All I'll tell you is that, if  []
Showing entries 1 to 1