OraFAQ Forum: MySQL » How get data from Mysql to Oracle table , by create oracle form

Home » Open Source » MySQL » How get data from Mysql to Oracle table , by create oracle form (Oracle6, OracleDB10g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How get data from Mysql to Oracle table , by create oracle form [message #438913]

Wed, 13 January 2010 00:37

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

Report message to a moderator

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

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

salora
Messages: 26
Registered: December 2009
Location: Thailand

Junior Member

hi Littlfoot,
Thank you for giving me some idea.
Surprised

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21823
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?

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Not PING, but TNSPING.

As of TNS_ADMIN, read my message here.

Report message to a moderator

Previous Topic:	MySQL
Next Topic:	convert data from MySQL table to Oracle table by php

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 20:09:17 CST 2024