Connection between Oracle Server and SQL Server 2008

Posted by Naeem2049 under Sql Server on 1/5/2011 | Points: 10 | Views : 11751 | Status : [Member] | Replies : 4
Hi All,

I want to make connection between Oracle and SQL Server 2008 Database servers.

problem is that i have 1 database in Oracle database i want to access that Oracle database in SQL Server 2008. I don't want to import and export tables.

Just access Oracle database in SQL Server 2008. How to make Connection between them???????

Please help me in this problem.

Thanks in advance




Responses

Posted by: T.saravanan on: 1/5/2011 [Member] [MVP] Silver | Points: 25
Posted by: PandianS on: 1/5/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi

You can use Oracle through the Linked Server using the Oracle provider "MSDAORA"

Cheers
www.sqlserverbuddy.blogspot.com


Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Naeem2049, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 1/5/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
You can directly connect using the SQL server management studio bu giving the Oracle credentials

Thanks
Karthik
www.f5Debug.net

Naeem2049, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Naeem2049 on: 1/5/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

Thanks to all.

Naeem2049, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response