cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Adapter Error

arunneerolil
Contributor
0 Kudos

Hi All,

We are tring to connect to MSSQLServer2000.

XI version is 3.0(SP15).

Do we have to install the driver ??

Which all drivers are vailable by default ??

We tried giving com.microsoft.jdbc.sqlserver.SQLServerDriver.

The following error is seen in adapter monitoring :-

'jdbc:microsoft:sqlserver://mysqlserver:1433;DatabaseName=tempdb'

failed: DriverManagerException: Cannot establish connection to

URL 'jdbc:microsoft:sqlserver://mysqlserver:1433;DatabaseName=tempdb'

: SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

Can anyone help.

Thanks in Advance

Chemmanz

Accepted Solutions (0)

Answers (2)

Answers (2)

bhavesh_kantilal
Active Contributor
0 Kudos

Hi,

<i>Which all drivers are vailable by default ??</i>

No driver is available by default. You need to install the driver to any DB that you want to access.

If a driver is deployed, you will find an entry in the JDBC adapter monitoring saying AVAILABLE DRIVERS : and a list of drivers.

Regards,

Bhavesh

Former Member
0 Kudos

Hi,

this link tells you what are the drivers available for any database:

http://developers.sun.com/product/jdbc/drivers

There are some motre details availble on this htread:

Regards

Vijaya

Message was edited by: vijaya kumari

bhavesh_kantilal
Active Contributor
0 Kudos

Hi,

To access any Database from XI, you will have to install the corresponding Driver on your XI server.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

You need to deploy MSSQL server's driver.

After doing the same, you can connect using following parameters,

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

Regards,

Bhavesh