Home » Open Source » MySQL » How get data from Mysql to Oracle table , by create oracle form (Oracle6, OracleDB10g )
How get data from Mysql to Oracle table , by create oracle form [message #438913] Wed, 13 January 2010 00:37 Go to next message
salora
Messages: 26
Registered: December 2009
Location: Thailand
Junior Member
Hi all,

I got the urgent assignment to create a oracle form to retrivr data from Mysql to Oracle table. So far , i have no idea to do that.

Anyone, please help. I very appliciate for that.

Thank you in addvance for your help

Sad

Re: How get data from Mysql to Oracle table , by create oracle form [message #438918 is a reply to message #438913] Wed, 13 January 2010 01:08 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"ODBC" might be the keyword you are looking for; check, for example, How To Access MySQL from Oracle With ODBC and SQL.
Re: How get data from Mysql to Oracle table , by create oracle form [message #438921 is a reply to message #438918] Wed, 13 January 2010 01:17 Go to previous messageGo to next message
salora
Messages: 26
Registered: December 2009
Location: Thailand
Junior Member
hi Littlfoot,
Thank you for giving me some idea.
Surprised
Re: How get data from Mysql to Oracle table , by create oracle form [message #438957 is a reply to message #438921] Wed, 13 January 2010 03:42 Go to previous messageGo to next message
salora
Messages: 26
Registered: December 2009
Location: Thailand
Junior Member
Hi all.

I has create ODBC and test , It's can connect succesfully,

Then, I has edit tnsnames.ora by add new SERVICE_NAME , as per as the created ODBC.

but I can not connect to that ODBC via sqlplus or Oracle form.

What is missing? or Do I need to do something more?

Pls. suggest me.

thanks in addvance.
Re: How get data from Mysql to Oracle table , by create oracle form [message #438962 is a reply to message #438957] Wed, 13 January 2010 04:05 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How many TNSNAMES.ORA files do you have? More than one (which is the case if you have installed a few Oracle products)? If so, do you use the correct one (setting the TNS_ADMIN environment variable might help here)? Can you TNSPING that MySQL database?
Re: How get data from Mysql to Oracle table , by create oracle form [message #438964 is a reply to message #438962] Wed, 13 January 2010 04:21 Go to previous messageGo to next message
salora
Messages: 26
Registered: December 2009
Location: Thailand
Junior Member
Hi Littel foot,

Thank you for your reply

I have've 5 TNSNAMES.ORA files as following detail...

1 in C:\orant\NET80\ADMIN ---> (add new SID oready)
2 in C:\orant\NETWORK\ADMIN ---> (add new SID oready)
3 C:\orant\NET80\TNSAPI ---> (not add new SID yet)
4 C:\orant\NETWORK\ADMIN\SAMPLE ---> (not add new SID yet)
5 C:\orant\NET80\ADMIN\SAMPLE ---> (not add new SID yet)

and I Can PING that MySQL database by use command in command prompt

"ping (ip addrss of mysql server)"


also.. How to setting the TNS_ADMIN environment variable , by the way?


Thank you very much for your help.
Re: How get data from Mysql to Oracle table , by create oracle form [message #438970 is a reply to message #438964] Wed, 13 January 2010 04:47 Go to previous message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not PING, but TNSPING.

As of TNS_ADMIN, read my message here.
Previous Topic: MySQL
Next Topic: convert data from MySQL table to Oracle table by php
Goto Forum:
  


Current Time: Tue Mar 19 00:58:36 CDT 2024