Hi Mark,
First set up an ODBC data source for your MySQL database, using MyODBC.
How do i do this.
regards
anandkl
On 9/19/05, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Hi Mark,
> Thanks for the email. Yes i also read about this.
> But the problem with this approach is since our oracle db is
: database link
You may want to think about doing this the opposite way around also, and
look at pushing the data from Oracle in to MySQL. Oracle has something
called "heterogeneous services", which allows you to define ODBC
datasources
as valid entries in the tnsnames.ora file. Then you co
Hi Mark,
Thanks for the email. Yes i also read about this.
But the problem with this approach is since our oracle db is a production
database which runs 24*78 and during night time it runs lot of other jobs i
cannot make the reporting job run from this oracle database.
regards
anandkl
On 9/16
Hi Mark,
Thanks for the email. Yes i also read about this.
But the problem with this approach is since our oracle db is a production
database which runs 24*78 and during night time it runs lot of other jobs i
cannot make the reporting job run from this oracle database.
regards
anandkl
On 9/16
You may want to think about doing this the opposite way around also, and
look at pushing the data from Oracle in to MySQL. Oracle has something
called "heterogeneous services", which allows you to define ODBC datasources
as valid entries in the tnsnames.ora file. Then you could simply create a
job
espond to
[EMAIL PROTECTED]
To
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
cc
Subject
Re: database link
Hi Green,
Right now we are doing the same way. The current reporting db is on
oracle, so we use a cronjob and the scripts connects to main db using
database link and
No. You will need to use an application external to the server to perform
the data collection process. This application can be one you write
yourselves or something you purchase. There are many ways to perform
things on a schedule:
a) you application continuously runs and performs certain actio
Hi Ananda,
I am not sure what do you mean by connecting MySQL to Oracle:
* Is it a permanent connection
* Do you want to transfer data from one to the other
* or ?
Mikhail Berman
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 15, 2005 10:33
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 i
