

SQL Server 2014 JDBC Adapter Required libraryĭownload Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. Start DataSpiderServer and DataSpider Studio.When using Integrated Windows Authentication, copy sqljdbc_auth.dll to the directory on the Windows system path of the computer on which JDBC driver is installed.Copy sqljdbc42.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2016_adapter.Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.sqljdbc_auth.dll (when using Integrated Windows Authentication)ĭownload Microsoft JDBC Driver 4.2 for SQL Server from Microsoft Download Center.

jar libraries to its classpath after the restart.Library Installation Library Installation SQL Server 2016 JDBC Adapter Required library Integration Server_directory\instances\instance_name\packages\WmJDBCAdapter\co Use the sqljdbc4.jar class library, which provides support for JDBC 4.0. Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Adapter Runtime (Connection): Unable to configure connection manager. Adapter Runtime (Connection): Unable to enable connection resource MySecondTest.SQLServerConnection:SQLServerConnection. Then I try to click on Enable to"Yes" I am getting the below error. I already download the jdbc driver 4.0 jar files from microsoft website and copied to the “C:\SoftwareAG\IntegrationServer\lib\jars” location and I restart the IS server also. I am creating the JDBC adapter connection using sql server 2005.
