Skip to Content
0
Former Member
Sep 19, 2007 at 05:27 AM

Database connection between ORACLE 9i(linux sap ecc5.0) and Ms_SQL 2000

49 Views

Hi experts,

Here current scenario is to establish database connectivity between ORACLE on linux (SAP ECC 5.0) to Ms_SQL 2000 on 2000 server.

Steps that i had followed are:-

1*Created one User for the respective Database. (with full read write access to concernd database "GYAPOS")

2* from SAP i had configured DBCO, by assiging the parameters as:-

i.e. connection information,

MSSQL_SERVER=tcp:192.168.1.213,MSSQL_DBNAME=GYAPOS,OBJECT_SOURCE=gyapos

user name a nd password is correct.

even then, i'm not able to connect to Ms_SQL data base.

if there is any requirement please let me know.

recently we had updated the kerenl and the database library files.

request you to clarify my doubts:-

1*are there any separate dll's required to establish connection.

2*do we nned to put one windows application server to LINUX (sap Ecc 5.0), so that i can have a connection to ms_SQL server which is running on 2000 server.

3*in what ways we can test connection, when we happend to create Dbco connection from SAP database to another non-sap database.

thanking you in all,

best regards,

raghav