Appropriate JDBC drivers for 7.0 version and SP16

[Former Member]

Hi all

we are using XI 7.0 SP 16.

what type/verion of JDBC drivers should be used for database connectivity?

while i was going through "How to install external JDBC Drivers" it was suggesting to use

Oracle 9i and Oracle 10g:

ojdbc14.jar

u2022 Microsoft SQL Server:

msbase.jar, mssqlserver.jar, msutil.jar

(in screen shots as well it was showing he was using msbase.jar, mssqlserver.jar, msutil.jar and ojdbc14.jar)

should we use both ojdbc14.jar and msbase.jar, mssqlserver.jar, msutil.jar or else one of them would be sufficient?

Is OJDBC a type 4 and type 2 driver?

Full Points are guaranteed

Regards

Bhasker

[Former Member · Accepted solution]

Hi,

You have to use ojdbc14.jar or classes12.zip/.jar for Oracle and msbase.jar, mssqlserver.jar, msutil.jar for Microsoft SQL Server. Thus both are required to be deployed on J2EE server.

And Oracle JDBC is a type 4 driver.

refer --> http://www.aquafold.com/docs-jdbcdrivers-oracle10g.html

Refer

SAP Note : 1078420, 831162, 941317, 1138877

Thanks

Swarup

Edited by: Swarup Sawant on Aug 4, 2008 10:25 AM

[Former Member · Accepted solution]

HI all

Thanks we are using OJDBC14.jar

Regard

Bhasker

[Former Member]

thanks

[Former Member]

for MS SQL Server Database.

msbase.jar, mssqlserver.jar, msutil.jar is enough...

based on Database, Install Appropriate Driver

[Former Member]

Hi

JDBC Driver are nothg to do with Version of XI, it's always checked with compatibility with u r DB which u r using.

But well make sure that those drivers are comptabile with JDK 1.4 as XI runs on that version.

Hi based upon u r DB choose files mentioned no need to put all drivers of SQL when u r using Oracle DB

Useful Notes:

Note 831162, Note 941317:, note 941317.

rgds

srini