Library Installation
SQL Server 2014 JDBC Adapter
Required library
- sqljdbc4.jar
- sqljdbc_auth.dll (when using Integrated Windows Authentication)
Driver Version
Microsoft JDBC Driver 4.0 for SQL Server
To Get the Library
Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. (http://www.microsoft.com/en-us/download/details.aspx?id=11774)
Installation
- Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
- Copy sqljdbc4.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2014_adapter.
- 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.
- Start DataSpiderServer and DataSpider Studio.
SQL Server 2012 JDBC Adapter
Required library
- sqljdbc4.jar
- sqljdbc_auth.dll (when using Integrated Windows Authentication)
Driver Version
Microsoft JDBC Driver 4.0 for SQL Server
To Get the Library
Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. (http://www.microsoft.com/ja-jp/download/details.aspx?id=11774)
Installation
- Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
- Copy sqljdbc4.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2012_adapter.
- 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.
- Start DataSpiderServer and DataSpider Studio.
SQL Server 2008 R2 JDBC Adapter
Required library
- sqljdbc4.jar
- sqljdbc_auth.dll (when using Integrated Windows Authentication)
Driver Version
Microsoft JDBC Driver 4.0 for SQL Server
To Get the Library
Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. (http://www.microsoft.com/ja-jp/download/details.aspx?id=11774)
Installation
- Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
- Copy sqljdbc4.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2008r2_adapter.
- 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.
- Start DataSpiderServer and DataSpider Studio.
SQL Server 2008 JDBC Adapter
Required library
- sqljdbc4.jar
- sqljdbc_auth.dll (when using Integrated Windows Authentication)
Driver Version
Microsoft JDBC Driver 4.0 for SQL Server
To Get the Library
Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. (http://www.microsoft.com/ja-jp/download/details.aspx?id=11774)
Installation
- Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
- Copy sqljdbc4.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2008_adapter.
- 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.
- Start DataSpiderServer and DataSpider Studio.
SQL Server 2005 JDBC Adapter
Required library
- sqljdbc4.jar
- sqljdbc_auth.dll (when using Integrated Windows Authentication)
Driver Version
Microsoft JDBC Driver 4.0 for SQL Server
To Get the Library
Download Microsoft JDBC Driver 4.0 for SQL Server from Microsoft Download Center. (http://www.microsoft.com/ja-jp/download/details.aspx?id=11774)
Installation
- Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
- Copy sqljdbc4.jar to directly beneath directory $DATASPIDER_HOME/server/plugin/data_processing/modules/sqlserver2005_adapter.
- 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.
- Start DataSpiderServer and DataSpider Studio.