Re: Access, ODBC, Oracle, MySQL

2005-09-29 Thread Robert Citek
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

Re: Access, ODBC, Oracle, MySQL

2005-09-28 Thread SGreen
Robert Citek <[EMAIL PROTECTED]> wrote on 09/28/2005 04:01:33 PM: > > On Sep 28, 2005, at 2:37 PM, Sujay Koduri wrote: > > I don't know how far this is going to help you. But this is what we > > are > > following to migrate from Oracle to MySQL. > > If we were migrating, that's probably the st

RE: Access, ODBC, Oracle, MySQL

2005-09-28 Thread Berman, Mikhail
Robert, I have not worked for a while with Crystal Reports and I do not know if CR allows to go across different database type, and are you willing to spend the money on it, but for plain querying Crystal Reports works well using ODBC connections. CR works where MS-Access fails, because MS-Access

Re: Access, ODBC, Oracle, MySQL

2005-09-28 Thread Robert Citek
On Sep 28, 2005, at 3:09 PM, Sujay Koduri wrote: Once you get some "Here's how you do it." about option 1, please post it in the lists also. Because we are also looking to do a similar one, but didn't find out any good info. I have been looking through here, but have not found anything c

RE: Access, ODBC, Oracle, MySQL

2005-09-28 Thread Sujay Koduri
September 29, 2005 1:32 AM To: MySQL Subject: Re: Access, ODBC, Oracle, MySQL On Sep 28, 2005, at 2:37 PM, Sujay Koduri wrote: > I don't know how far this is going to help you. But this is what we > are following to migrate from Oracle to MySQL. If we were migrating, that's pro

Re: Access, ODBC, Oracle, MySQL

2005-09-28 Thread Robert Citek
On Sep 28, 2005, at 2:37 PM, Sujay Koduri wrote: I don't know how far this is going to help you. But this is what we are following to migrate from Oracle to MySQL. If we were migrating, that's probably the strategy that we would use. But we are not, at least not yet. For now we just want

RE: Access, ODBC, Oracle, MySQL

2005-09-28 Thread Sujay Koduri
I don't know how far this is going to help you. But this is what we are following to migrate from Oracle to MySQL. Have a flag keeporacle as long as you want oracle to be in place. Open connection to mysql If (keeporacle) { open connection to oracle also. } if (keepOracle)