DbSchema is connecting to MSSql 2005 using JDBC Drivers.
What are JDBC Drivers?
JDBC drivers are Java library files with the extension '.jar', used by Java applications to connect to the database.
Usually they are provided by the same company which developed the database software.
DbSchema is an MSSql 2005 Client which already includes
the MSSql 2005 JDBC driver. DbSchema can configure the MSSql 2005 JDBC URL and test the connectivity.
What is the JDBC URL?
The URL is a string (text) with a specific format containing information about the host where the database is running, the port, username, database name, etc.
The URL format is specific to each driver.
Any wrong character in the URL may make the database connectivity fail.
Therefore we recommend installing DbSchema and try to get connected, and you will find the JDBC URL in the connection dialog.
Driver Information
- Required File(s): sqljdbc.jar
- Java Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
- URL: jdbc:weblogic:mssqlserver4:DB@HOST:PORT
- Website: Microsoft
jTDS JDBC Driver
Download the jtds-nn-dist.zip file, unzip it and then load the jtds.jar file
- Required File(s): jtds-1.2.2.jar
- Java Driver Class: net.sourceforge.jtds.jdbc.Driver
- URL: jdbc:jtds:sqlserver://HOST[:PORT][/DB][;instance=PARAM]
jdbc:jtds:sqlserver://HOST[:PORT][/DB];domain=PARAM;integratedSecurity=true
jdbc:jtds:sqlserver://HOST:PORT/DB
- Website: jTDS web site
Download MSSql before 2006 JDBC Driver
The driver files are compressed in a zip file.
for any issues with the driver, you can write to us.