JDBC drivers for MSSQL 7.0

[Former Member]

Hi,

We have installed JDBC drivers for MSSQL by following guide "how to install and configure a JMS and JDBC adapter" and they are "msutil.jar, mssqlserver.jar, msbase.jar". Our platform is NETweaver 2004s PI 7.0 on UNIX and Oracle.

The interfaces are working fine when we are sending data to MSSQL 2000, but when we are sending data to MSSQL 7.0, we are getting errors incompatible drivers.

Are there seperate drivers MSSQL 7.0 or we need to have different set of drives. Checked Note 639702 and as per note we should be able to find drivers installed on system at

- (NetWeaver 2004s:)

usr\sap\<SAPSID>\SYS\exe\<NUC|UC>\Platform\mssjdbc

I did not find the 'Platform' in my system at the above mentioned path.

Can anyone help us with this issue.

Thank You,

Praveen

[Former Member · Accepted solution]

Hi Praveen,

As I know, there is no JDBC driver MSSQL 7.0, so there is no direct way to get access to it.

But there is another way to do it if you have access to a MSSQL 2000 or above server.

In MSSQL 2000 you can create a linked server to the MSSQL 7.0, and then you can use XI to get access to MSSQL 7.0 tables.

Regards,

Hui

[Former Member]

Could not find any answer for this question. Although everyone I spoke had the similar answer.