cancel
Showing results for 
Search instead for 
Did you mean: 

Error while using JDBC adapter

Former Member
0 Kudos

Hello friends,

I have configured JDBC adapter to update a database and am getting the following error message.

Error during database connection to the database URL 'jdbc:sqlserver://192.168.1.31:1480;DatabaseName=iCSales' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://192.168.1.31:1480;DatabaseName=iCSales': SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver'

I have made sure that XI server's firewall is switched off for the time being, but still getting this error.

What may be the possible reasons that I should be looking into?

Any feedback will be greatly appreciagted.

Thanks

Ram

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

thanks everyone for the responses

Former Member
0 Kudos

Also check for username / password used to connect sql server. You will get same error if username / password is wrong.

Check CC status in RWB..you will get more details about error.

Nilesh

Former Member
0 Kudos

Thanks a lot guys.

This is a new installation and so I don't think we have the drivers installed. Since we don't have a basis guy on site, I have to find out from the consultatnt who worked for a week to install our stuff few weeks back.

Where can i get this driver, if I have to install? Will it be on one of the CDS that we got from SAP?

We have installed both ECC and Netweaver (XI and Portal).

Any suggestions would be highly appreciated.

Thanks

Ram

Former Member
0 Kudos

Hi,

You can download JDBC dricer for SQL server from below link..

http://msdn2.microsoft.com/en-us/library/ms378526.aspx

Here is the steps / process to install drivers..

Nilesh

Former Member
agasthuri_doss
Active Contributor
0 Kudos

Hi,

Adding to Bhavesh

Check whether you have mentioned the driver file in Provider XML file.

Regards

Agasthuri Doss

bhavesh_kantilal
Active Contributor
0 Kudos

<b>SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver'</b>

Has the JDBC driver been installed on the XI server corresponding to your SQL server?

Regards

Bhavesh