Connecting SQl Server from Oracle DB which Is installed on Unix
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   shrinath_kunchipudi
Posted On:   Friday, May 28, 2010 04:46 AM

Hi,
I need to connect SQL Server from Oracle DB. I never Did this before.
Can some one give me the Steps to perform such a activity please .




Please use html tags to format code blocks.

Report | Quote This | Send private message | Reply | Print

Re: Connecting SQl Server from Oracle DB which Is installed on Unix

Posted By:   tim_fox  
Posted On:   Thursday, July 1, 2010 12:22 PM

You can set up Oracle's Heterogeneous Services which allows you to connect to any ODBC datasource. If your Oracle database is running on Unix/Linux, you will need ODBC drivers for that OS (most are free for Unix/Linux). Then your Oracle db can connect to SQL Server via a database link.


TGF

Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact