Microsoft SQL Server Driver.
Official download
https://learn.microsoft.com/zh-cn/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view= ; SQL server ver16.
Official compatibility instructions https://learn.microsoft.com/zh-cn/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view= ; SQL server ver16.
The official couldn't find the download of sqljdbc4. jar. Previously, I configured sqljdbc4. jar under dbvis to link to sqlserver2000, and this driver is also used in the web data source in Centos
After upgrading to 2008, dbiv worked normally, but web failed. web reported errors such as SSLv3.
Then download the new version of the official website, only adding mssql-jdbc-11.2 *. jar under dbvis, unable to connect to sqlserver2000, indicating that it does not support sqlserver 8 databases. Connect to 2008, as previously mentioned with SSLv3, etc. Then add mssql-jdbc-auth *. ddl and connect to 2008 normally.
In the driver wizard for creating a driver for Websphere in Centos, rest assured of the location of the jar package [variable]/sqljdbc4. Replace jar with the actual mssql-jdbc-11.28. jar. The auth.ddl file is not useful in Centos, but it can connect to 2008 normally. From the backend, it can be seen that.
- Mssql-jdbc-11.2 *. jar connection 2008, corresponding to database version 10, jdbc specification 4.2
- Sqljdbc4. jar connection 2000, database version 8, driver version 2.0, jdbc specification 3.0
Auth.ddl seems to be related to either Windows authentication or SQL server authentication in the database configuration, but auth is only suitable for Windows platform clients.