Which jar to use for connecting to MS SQL server

java sql sql-server jdbc mssql-jdbc
Amit picture Amit · Mar 19, 2010 · Viewed 47k times · Source

Can some one please guide me to understand which jar file i need to include in my application to be able to set up a jdbc connection with ms sql server.

thanks in advance.

Answer

kevchadders picture kevchadders · Mar 19, 2010

sqljdbc.jar and sqljdbc4.jar class library files to be used depending on your preferred Java Runtime Environment (JRE) settings. For more information about which JAR file to choose, see System Requirements for the JDBC Driver.

Downloads links and more information can be found here.

Related questions

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption

I used this code to create a connection to SQL Server. String connectionUrl = "jdbc:sqlserver://IP:1433;" + "databaseName=db;user=db;password=pwd"; Connection con = null; try { // Establish the connection. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(connectionUrl); …

Read More
Windows Authentication for SQL Server using JBDC on a Mac

Is it possible to connect to SQL Server using Windows authentication/integrated security from a Mac? I am using the type 4 JDBC driver provided by Microsoft. The front end (a form application) is coded in Java. Everything works perfectly on …

Read More
What are the difference between: sequence id using JPA @TableGenerator, @GeneratedValue vs database Auto_Increment

Q1.: What is the difference between applying sequence Id in a database using A. CREATE TABLE Person ( id long NOT NULL AUTO_INCREMENT ... PRIMARY KEY (id) ) versus B. @Entity public class Person { @Id @TableGenerator(name="TABLE_GEN", table="SEQUENCE_TABLE", …

Read More