Can someone give me the summary of right parameters and corr

, ,
1

The error I am getting when I try configuring a database connection to an SQL server is as follows.

The JDBC DataSource class “com.microsoft.jdbcx.sqlserver.SQLServerDataSource” cannot be located.
com.microsoft.jdbcx.sqlserver.SQLServerDataSource.class not founduser sa

Here’s the set of parameters I specify (note the 4 \ in the server name to actually represent a server - \XYZ)

Connection Type: JDBC Adapter Connection
Package Name: abc
Connection Properties
Transaction Type: NO_TRANSACTION
DataSource Class: com.microsoft.jdbcx.sqlserver.SQLServerDataSource
serverName: \\XYZ
password ******
databaseName
portNumber 1433
networkProtocol
Other Properties
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

2

You will need to install the drivers on the IS.

  1. Download the SQL Server drivers from microsoft
    http://www.microsoft.com/sql/downloads/default.asp

  2. Put the downloaded files in the /IntegrationServer/lib/system directory

  3. Restart the IS

3

Thank you very much Brian. It helped. The absence of jar files from the IntegrationServer\lib\jars folder was causing problems.