Connection from Oracle/unix to MSSQL

[Former Member]

We have a Sap BI instance Abap+J2EE 70, latest patch, on Oracle Unix.

We need to connect this SAP BI to an external database MSSQL, on Windows.

According note 323151 it is an heterogeneous connection.

Any idea about how to do that ?

Regards

[Former Member]

Hi

Please check if the following link helps you:

http://www.dba-oracle.com/t_heterogeneous_database_connections_sql_server.htm

and

http://ora-28500.ora-code.com/msg/24215.html

Regards

Chen

[Former Member]

solved.

The solution was to open the jar file uploaded on the J2EE and to check the real drive string ; it's written into a file.

[Former Member]

plz we can close the thred

[manu_susankar]

Hi roberto mariani ,

Please check white paper [Here |http://msdn.microsoft.com/en-us/library/dd299430.aspx]

Regards,

S.Manu.