Re: dblink mysql to oracle

2002-06-03 Thread Igor Neyman
Read on Oracle's Heterogeneous Services, allows to connect (through db-link) to foreign databases using ODBC. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 02, 2002 8:08 PM i want to be

RE: dblink mysql to oracle

2002-06-03 Thread Gogala, Mladen
:[EMAIL PROTECTED]] Sent: Sunday, June 02, 2002 8:08 PM To: Multiple recipients of list ORACLE-L Subject: dblink mysql to oracle i want to be able to select mysql data from oracle simular (in some way) to how i do via dblinks 'select * from table@otherdb' is there a way to do something

RE: dblink mysql to oracle

2002-06-03 Thread Gabriel C Millerd
On Mon, 3 Jun 2002, Gogala, Mladen wrote: I dunno about MySQL, but from oracle you can have external procedures accessing MySQL and returning data into oracle. There is also a TNS API which allows you to write your very own transparent gateway and select data from MySQL. is this the

Re: dblink mysql to oracle

2002-06-03 Thread Gabriel C Millerd
On Mon, 3 Jun 2002, Igor Neyman wrote: Read on Oracle's Heterogeneous Services, allows to connect (through db-link) to foreign databases using ODBC. this seems more like the way to go .. i didnt expect to have to program anything rather configure oracle, a mysql driver, and transport

dblink mysql to oracle

2002-06-02 Thread Gabriel C Millerd
i want to be able to select mysql data from oracle simular (in some way) to how i do via dblinks 'select * from table@otherdb' is there a way to do something like this? --- Gabriel C. Millerd | Eternal nothingness is fine if you happen to be Super Plumber | dressed for