On Sep 28, 2005, at 4:03 PM, [EMAIL PROTECTED] wrote:
(1) is almost possible with 5.0. The Federated storage engine
creates the
equivalent of "linked tables" but it is MySQL-to-MySQL only. There are
other restrictions, too. As soon as they work out the kinks for
MySQL-to-ODBC, you will be in business. Full details:
http://dev.mysql.com/doc/mysql/en/federated-storage-engine.html
Except that our data and all its infrastructure will need to be
upgraded and tested, too. Not something that will happen any time soon.
(2) This was suggested earlier (just last week) and an example was
walked
through on the list. Really, this is an Oracle question and I would
happily refer you to any Oracle docs on how to create such an ODBC-
linked
table. I don't know where to look so I Googled:
http://www.google.com/search?hl=en&q=oracle+heterogenous+link
+odbc&btnG=Google+Search
(hit #2)This link seems promising. Try substituting references to
their
drivers with references to the MyODBC driver:
http://www.easysoft.com/applications/oracle/hsodbc.html
(hit #4)This also looks to be useful. Substitute MS SQL server
information
with MySQL values where appropriate.
http://www.databasejournal.com/features/oracle/article.php/3442661
(hit #5) (OMG!!) This one actually describes linking Oracle to MySQL :
http://techrepublic.com.com/5100-9592-5725974.html
One of these or some of the other appx 48500 other hits has GOT to
work
for you.
Thanks for the links. We are trying them out.
Yes, Google is nice and of the 48500 hopefully one will work. But
I'm also curious to know if anyone here on this list has actually
gotten MySQL and Oracle to interoperate? Lots of hits via Google are
not very useful if no one is able to reproduce the results.
Regards,
- Robert
http://www.cwelug.org/downloads
Help others get OpenSource software. Distribute FLOSS
for Windows, Linux, *BSD, and MacOS X with BitTorrent
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
