on 10-22-2007 8:06 PM
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
thanks everyone for the responses
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hi
JDBC Driver Deployment Guide...
Thanks
Hi,
Adding to Bhavesh
Check whether you have mentioned the driver file in Provider XML file.
Regards
Agasthuri Doss
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.