I would like to know whether I am giving proper information when setting up JDBC connection to SQL Server.
I have copied the jar files msutil.jar, msbase.jar and mssqlserver.jar under …/IntegrationServer/packages/WmJDBCAdapter/code/jars/static/ and restarted the server.
Other than the above jar files, do i need to install any other jars?
In the connection details, I am using datasource class as com.microsoft.jdbcx.sqlserver.SQLServerDataSource and providing servername, databasename, userid, pw, port,
What should i mention in Network Protocal and OtherProperties? Please let me know.