JDBC Adapter Error

[Former Member]

I have configured my JDBC to connect to sql server 2005.

: Error: Accessing database connection 'jdbc:sqlserver://SAPSERVER:1433;databaseName=san' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://SAPSERVER:1433;databaseName=san': SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

- 2008-08-19 02:59:45 PDT: Processing started

I did look into market place - found this

.ClassNotFoundException while using SQL Server 2005 Driver

• Q: I am not able to connect to DB using SQL Server 2005 driver if I use com.microsoft.jdbc.sqlserver.SQLServerDriver as driver class name. I get classNotFoundException. Why?

A: Driver class names for SQL Server 2000 driver and SQL Server 2005 driver are different.

If you are using SQL Server 2005 driver, then class name should be as follows:

Driver class: com.microsoft.sqlserver.jdbc. SQLServerDriver

URL :jdbc:sqlserver://<db_Server>:port;databaseName=< db_name>

If you are using SQL Server 2000 driver , then class name should be as follows:

Driver class: com.microsoft.jdbc.sqlserver. SQLServerDriver

and URL is as follows:

jdbc:microsoft:sqlserver://<db_server>:port; databaseName=<db_name>

I did go through the forum and checked as this file is present....

\usr\sap\DM0\DVEBMGS01\j2ee\cluster\server0\bin\ext\com.sap.portal.jdbcdrivers\P9sqlserver.jar

Any idea - how to fix this ??

Thanks in advance.

[Former Member]

Hi,

The main problem is that you are not able to establish the connection to your database, there could be few reasons for it, just check it out.

1. The port should be correct

2. User name & password must be correct

3. There should not be any firewalls

4. Make sure database is up & running

5. You must have installed correct drivers

[Former Member]

Hi,

Change the connection string like below..

jdbc:microsoft:sqlserver://SAPSERVER:1433;databaseName=san

Regards,

Prakasu

[Former Member]

The one you are suggesting is for SQL server 2000.

Thanks.

[Former Member]

Hi sanju,

you have to deploy the SQLServerDriver

Regards Mario

[Former Member]

com.sap.portal.jdbcdrivers\P9sqlserver.jar

is deployed under run time in visual admin.

[Former Member]

Sanju,

Are you sure about the name of the JAR file used to deploy SQLServer2k5 : P9sqldriver.jar ?

Rgds

Chris

[prateek]

Make sure u have installed the drivers. What driver are u using in the channel.

Regards,

Prateek

[Former Member]

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Connections : jdbc:sqlserver://SAPSERVER:1433;databaseName=san

Thanks

[Former Member]

> Connections : jdbc:sqlserver://SAPSERVER:1433;databaseName=san

Try to put ip address istead of server name also change the default port from 1433 to 1430. e.g.

jdbc:sqlserver://192.168.10:1430;databaseName=san

[Former Member]

I checked the ports - it 1433 and tried IP too