db link between oracle erp db (11.1.0.7 ) and sqlsever 2008 db

Mohammed Abdul Muqeet

Dear Experts,

Kindy note that I am stuck in the below scenario.

We are trying to create a db link between oracle db - R12.1.1 + 11.1.0.7(SUN SPARC 64-bit). and SQL Server 2008 Installed on

Windows Server 2008 R2.

We are planning to integrate 3rd party application along with oracle erp.


Please advise.


Regards
Mohammed. Abdul Muqeet

Mohammed Abdul Muqeet

Wanted to know on how to create the db link between oracle db and sql server db.

Could you please suggest any step by step document in this regards.


Thanks
Mohammed

Mohammed Abdul Muqeet

Experts/ Gurus,

Awaiting for your reply on this

Chanchal Wankhade

Hi,

If this can be helpfull to you.

http://www.mssqltips.com/sqlservertip/1433/how-to-setup-linked-servers-for-sql-server-and-oracle-64-bit-client/

http://www.dbaglobe.com/2009/09/how-to-adding-linked-server-for-oracle.html

http://www.kodyaz.com/articles/create-oracle-linked-server-query-data-from-oracle-to-sql-server.aspx