Create a jTDS connection string

by

As detailed in the jTDS Frequenlty Asked Questions, the URL format for jTDS is:

jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]

So, to connect to a database called “Blog” hosted by a MS SQL Server running on MYPC, you may end up with something like this:

jdbc:jtds:sqlserver://MYPC:1433/Blog;instance=SQLEXPRESS;user=sa;password=s3cr3t

Or, if you prefer to use getConnection(url, "sa", "s3cr3t"):

jdbc:jtds:sqlserver://MYPC:1433/Blog;instance=SQLEXPRESS

EDIT: Regarding your Connection refused error, double check that you’re running SQL Server on port 1433, that the service is running and that you don’t have a firewall blocking incoming connections.

More Related Contents:

  1. How to connect to Oracle using Service Name instead of SID
  2. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  3. Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern
  4. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  5. How to establish a connection pool in JDBC?
  6. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  7. Cannot issue data manipulation statements with executeQuery()
  8. JDBC Class.forName vs DriverManager.registerDriver
  9. IO Error: The Network Adapter could not establish the connection
  10. How to call oracle stored procedure which include user-defined type in java?
  11. How do I connect to a SQL Server 2008 database using JDBC?
  12. Java JDBC Access denied for user [closed]
  13. How often should Connection, Statement and ResultSet be closed in JDBC?
  14. How is driver class located in JDBC4
  15. Getting output from dbms_output.get_lines using JDBC
  16. JDBC ODBC Driver Connection
  17. Java – Can’t use ResultSet after connection close
  18. Timezones in SQL DATE vs java.sql.Date
  19. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  20. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  21. MySQL connector error “The server time zone value Central European Time” [duplicate]
  22. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  23. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  24. Connection cannot be cast to oracle.jdbc.OracleConnection
  25. NoClassDefFoundError sun/io/ByteToCharConverter with InterBase JDBC driver
  26. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  27. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  28. MyBatis executing multiple sql statements in one go, is that possible?
  29. A persistent connection with JDBC to MySQL
  30. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR

Leave a Comment