Your URL should be jdbc:sqlserver://server:port;DatabaseName=dbname
and Class name should be like com.microsoft.sqlserver.jdbc.SQLServerDriver
Use MicrosoftSQL Server JDBC Driver 2.0
More Related Contents:
- JDBC connection failed, error: TCP/IP connection to host failed
- What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
- Can I connect to SQL Server using Windows Authentication from Java EE webapp?
- java.sql.SQLException: Column count doesn’t match value count at row 1
- How do I connect to a SQL Server 2008 database using JDBC?
- SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
- JPA SQL Server No Dialect mapping for JDBC type: -9
- Native Library sqljdbc_auth.dll already loaded in another classloader
- Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29
- JDBC SQLServerException: “This driver is not configured for integrated authentication.”
- How to pass Table-Valued parameters from java to sql server stored procedure?
- Date columns in SQL-Server (MSSQL-JDBC 3.0) running under Java 1.7.0 retrieved as 2 days in the past
- ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
- How to get *everything* back from a stored procedure using JDBC
- Getting the Return Value from JDBC MSSQL
- Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
- The TCP/IP connection to the host localhost, port 1433 has failed
- java.sql.SQLException: No database selected – why?
- Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR
- Hours and seconds are lost when storing a date in the database [closed]
- ClassNotFoundException com.mysql.jdbc.Driver [duplicate]
- What is the actual use of Class.forName(“oracle.jdbc.driver.OracleDriver”) while connecting to a database?
- How to enable logging for SQL statements when using JDBC
- Difference between Oracle jdbc driver classes?
- Writing a large resultset to an Excel file using POI
- Retrieve an Image stored as BLOB on a MYSQL DB
- UNIX socket implementation for Java? [closed]
- Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
- Spring-Boot: How do I set JDBC pool properties like maximum number of connections?
- mysql prepared statement error: MySQLSyntaxErrorException