Connection between Oracle Server and SQL Server 2008

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	Hi, Refer this links...I think its useful to you... http://support.microsoft.com/kb/280106 http://www.sqlmag.com/article/sql-server/setting-up-an-oracle-linked-server49687.aspx http://www.databasejournal.com/features/oracle/article.php/3442661/Making-a-Connection-from-Oracle-to-SQL-Server.htm Thanks, T.Saravanan Naeem2049, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

0	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

0	Hi, Thanks to all. Naeem2049, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts