Skip to main content

Posts

Showing posts from July, 2013

JDBC Connection to MS SQL Server Issues ( Port, connection failed, Port 1433, 1434, etc)

Resources: http://blogs.msdn.com/b/jdbcteam/ Download Microsoft JDBC Driver 4.0 for SQL Server  http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx     * You will find 2 .jar files in the download! Difference between sqljdbc.jar and sqljdbc4.jar . (Find more at http://msdn.microsoft.com/en-us/library/ms378422.aspx ) JAR Description sqljdbc.jar sqljdbc.jar   support for JDBC 3.0., Java Runtime Environment (JRE) of version 5.0.  sqljdbc4.jar   support for JDBC 4.0 API. , Java Runtime Environment (JRE) of version 6.0 or 7.0. Using sqljdbc4.jar on JRE 5.0 will throw an exception.  Connection URL:  (REF: http://msdn.microsoft.com/en-us/library/ms378428.aspx ) jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;integratedSecuri...