Home » RDBMS Server » Server Administration » Connecting from Oracle to Non Oracle Systems
icon5.gif  Connecting from Oracle to Non Oracle Systems [message #165121] Tue, 28 March 2006 06:50 Go to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
Hi,

I am trying to connect to SQL server from Oracle.

Can any one help?

Thanks in Advance
SALIH KM Cool

Report message to a moderator

Re: Connecting from Oracle to Non Oracle Systems [message #165130 is a reply to message #165121] Tue, 28 March 2006 07:24 Go to previous messageGo to next message
wpaillan
Messages: 35
Registered: March 2005
Location: Santiago - Chile
Member
Hello
Very Simple, steps are these.

Data base Oracle

Creating a, User of Connection, Permanent.
This with permissions on the objects (table,Views,Etc) to utilize.

maquine Sql Server

1.- you need to have once a customer was installed oracle, proven and work, aiming at the data base Oracle, Create Host Oracle
2.- Administrating Corporate tools (SQL SERVER), creating a Linked Server, Utilizando "Microsoft OLE DB provider for Oracle", utilizing the Previous Host Oracle.

Imagine Now That you have called SERORA, to this Linked Servidor

Referencia's consultation will be :
1.- select * from SERORA..owner.table_name
2.- INSERT INTO SERORA..owner.table_name

Good that is everything

williams

Report message to a moderator

Re: Connecting from Oracle to Non Oracle Systems [message #165136 is a reply to message #165130] Tue, 28 March 2006 07:53 Go to previous message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
Hi

Thanks for your prompt reply.

Is it a connection from Oracle DB to Sql Server DB?

Regards
SALIH KM

Report message to a moderator

Previous Topic: "ORA-12154: TNS : Culd not resolve the connect identifier specified"
Next Topic: SQL Statement process
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:20:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.