DricverMangerException - Issue with JDBC and MS SQL

[Former Member]

Hi All,

we try reach our MS SQL server but we still get the error :

DriverManagerException: Cannot establish connection to URL

'JDBC:microsoft:sqlserver://XXX.X.XX.XXX:XXXX;DataseName=AAAA;': ClassNotFoundException:

com.microsoft.jdbc.sqlserver.SQLServerDirver

What have we done:

1. We have deployed the MS SQL JDBC driver for 2000 based on the JDBC configuration how to guide

2. When we are going to the VA we can see the deployed files:

2.1. base.jar

2.2. resource.jar

2.3. sqlserver.jar

2.4. util.jar

My questions:

1. Do we have to make any entry in the IR? As far as I know the Adapter objects are deliverd with the SAP Basis 7.0 which is deployed in the IR (SPS:12)

2. Can anybody of you tell me how we can solve this problem???

Regards

Markus

[Former Member]

Markus,

It looks like there is a typo in driver's classname:

com.microsoft.jdbc.sqlserver.SQLServerDirver

should be

com.microsoft.jdbc.sqlserver.SQLServerDriver (instead of Dirver)

Depending on MSSQL release (2K or 2K5), classname is not exactly the same

Chris

[Former Member]

Hi,

the typo is only in the thread, in the CC it is typed correct.. sorry..

[Former Member]

Markus,

My deployed JDBC MS SQL driver set contains :

msbase.jar

mssqlserver.jar

msutil.jar

Do you see them in their deployed SDA standard location /usr/sap/<SID>/DVEBMGS<SYSNO>

/j2ee/cluster/server0/bin/ext/com.sap

.aii.af.jmsproviderlib ?

Chris

[prateek]

Do we have to make any entry in the IR?

No

Try redeployin

Regards,

Prateek

[Former Member]

Hi,

we have depoyed the driver 2 times and also we changed the driver and deployes a driver fom a different sources.. always the same error....

Regards

Markus