Connecting Oracle on Sun to MS SQL Server

[mrdenny]

Does anyone know of a way to connect an Oracle DB Server running on Sun to a Microsoft SQL Server. The Oracle DB needs to be able to pull directly from the SQL Server.

Yes I know it would be easier to DTS the data from the SQL Server to Oracle but that's not an option.

Thanks,
Denny

 

[jinishans]

Hi,

U can create a linked server in SQL Server 7/2000 under security tree in Enterprise Manager and get the data from Oracle to SQL Server. i.e. Pulling Data from Oracle and u can update in SQL Server.

Yours,
Sankar.B

 

[mrdenny]

I'm trying to go the other direction. I need the Oracle server to connect to the SQL Server. I own the Oracle box, but the SQL Servers I'm trying to connect to belong to another department, so the SQL can't push.

Thanks,
Denny