3

I am attempting to create a new Data Service in WSO2 Data Services Server to connect with SQL Server 2005. However, every time I test the connection I receive the error message "Driver class com.microsoft.jdbc.sqlserver.SQLServerDriver can not be loaded". 

Data Source Type: RDBMS, Non-XA-DataSource
Database Engine: Microsoft SQL Server
Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver 
...

I don't believe my connection string or credentials are a problem as it fails on loading the driver.

What is the step that I'm missing in this process?

J0e3gan
  • 8,740
  • 10
  • 53
  • 80
Scott
  • 33
  • 1
  • 6

2 Answers2

6

You have to put the Microsoft SQL driver jar inside repository/components/lib of DSS distribution in order to load the driver class.

Lakmali Erandi Baminiwatta
  • 2,295
  • 15
  • 18
0

The folder structure has changed for Enterprise Integrator v6 you will need to drop off the file into your [EI_HOME]/lib folder. Default folder is "C:\Program Files\WSO2\Enterprise Integrator\6.6.0\lib".

Depending on what version of Java you are using, you may download the corresponding version from here.

Extract the file and you drop the jar:

  1. mssql-jdbc-7.2.2.jre8.jar - for java 1.8 class version 52

Check out this link for class versions.

JayKayOf4
  • 1,202
  • 1
  • 12
  • 15