#Microsoft jdbc driver 6.0 and for sql server driver#
Download MS SQL Server JDBC driver to C:\tempĢ. This will create JDBCVersion.class in current directoryġ. ("Product version: " + dm.getDatabaseProductVersion()) Ĭ:\Language\jdk1.8.0_92_64\bin\javac JDBCVersion.java ("Product name: " + dm.getDatabaseProductName())
![microsoft jdbc driver 6.0 and for sql server microsoft jdbc driver 6.0 and for sql server](https://docs.wingarc.com.au/superstar/files/9.10/88835326/88835332/1/1543877949786/worddava1675c153894fc91107c375102fb684c.png)
("Driver version: " + dm.getDriverVersion()) ("JDBC Driver version: " + dm.getJDBCMajorVersion() + "." + dm.getJDBCMinorVersion()) String dbURL = "jdbc:sqlserver://localhost\\SQLSERVER2012" Ĭonn = DriverManager.getConnection(dbURL, user, pass) ĭatabaseMetaData dm = (DatabaseMetaData) conn.getMetaData() JDBCVersionĭriver name: Microsoft JDBC Driver 4.1 for SQL Server JDBCVersionĭriver name: Microsoft SQL Server JDBC Driver 3.0ĭ:\temp\sqljdbc>java -cp C:\ClaimCenter9.0.0\admin\lib\sqljdbc-4.1.jar. JDBCVersionĭriver name: Microsoft JDBC Driver 4.0 for SQL Serverĭ:\temp\sqljdbc>java -cp C:\ClaimCenter7.0.7\lib\sqljdbc4.jar. JDBCVersionĭ:\temp\sqljdbc>C:\Language\jdk1.8.0_92_64\bin\java -cp sqljdbc4.jar. JDBCVersionĭriver name: Microsoft JDBC Driver 6.0 for SQL Serverĭ:\temp\sqljdbc>C:\Language\jdk1.8.0_92_64\bin\java -cp sqljdbc41.jar.
![microsoft jdbc driver 6.0 and for sql server microsoft jdbc driver 6.0 and for sql server](https://forum-cdn.knime.com/uploads/default/original/2X/5/50a08c3e1a310a0644e0058638dcf8337f7fc5e3.jpeg)
Therefore, I developed following Java application that can display both the JDBC version, as well as JDBC Version Complianceĭ:\temp\sqljdbc>C:\Language\jdk1.8.0_92_64\bin\java -cp sqljdbc42.jar. So when you received a file called sqljdbc.jar, it is hard to tell what version of Microsoft JDBC driver version it belongs to, but only able to tell it support JVM 1.5 or older.
![microsoft jdbc driver 6.0 and for sql server microsoft jdbc driver 6.0 and for sql server](https://i.ytimg.com/vi/x8GiogC4SdE/sddefault.jpg)
When you download the driver from Microsoft, it will include 4 JAR files, and you need to pick the proper JAR file according to your JVM version.įor example, following Microsoft JDBC 4.2 bundled with sqljdbc42.jar that needs JVM 1.8, sqljdbc41.jar that needs JVM 1.7, sqljdbc4.jar that needs JVM 1.6, and sqljdbc.jar that needs JVM 1.5.įrom this MSND, you can see that JDBC v4.2 has another versioning called JDBC Version Compliance for each file. Every Microsoft JDBC JAR version bundled with 4 sqljdbc.jar files for 4 different versions of major Java JVM.