** Is it not possible to use 2 database in same XI server

[jegathees_waran]

Hi friends,

We were able to connect to oracle database thru JDBC adapter previously. To connect to SQL server , we have installed JDBC drivers for Microsoft SQL Server 2000 in same XI server. Now, we are able to connect to SQL server table but not able to connect to Oracle table . When change the CC and give the Oracle driver and Connection string, it throws an error 'SAPClassnotFoundException'.

So, Is it not possible to connect to different database in same XI system ?

Kindly reply friends,

Kind Regards,

Jeg P.

[Former Member · Accepted solution]

1) Verify the DB URL by connecting database using Command line SQL plus or any SQL editor.

2) Check wether the Drivers deployed are supported for the Oracle Db version and JDK version on XI server and OS type ( Solaris )

Check this URL for details on JDBC drivers support list -

SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver' --> This error clearly implies that the OracleDriver has not been installed on your XI server.

Ask you admin team to do the needful and install the Oracle Drivers.

regards

kummari

[jegathees_waran]

We missed the ojdbc12.jar file when we install SQL server. After installed this, we are able to connect to both SQL and ORACLE database

[Former Member]

Hi,

I haven't done yet but it must be possible.

Maybe this helps:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Regards

Patrick