Ananda Kumar <[EMAIL PROTECTED]> wrote on 09/15/2005 10:33:16 AM: > Hi, > How can i connect from MYSQL db to an oracle database. Do we need to create > any database link or use some ODBC. > Please help > regards > anandkl
The only way to get one MySQL database server to directly manage data in a table that resides within another server is through the Federated storage engine. Federated is a new feature coming with v5.0 and is similar to MSSQL's "linked table" feature. Currently it only supports MySQL to MySQL table interactions. When you say "connect from MYSQL db to an oracle database" what exactly are you trying to accomplish? What are you trying to do? What problem are you having that you think the "connection" would solve? Please give us some additional details so we can answer your question more thoroughly. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
