MS SQL Server JDBC Driver and URL Information
|
Listed below are connection examples for common JDBC drivers for Microsoft SQL Server: jTDS Driver DRIVER CLASS: net.sourceforge.jtds.jdbc.Driver DRIVER LOCATION: Specify the location on your machine of the jar file containing the jTDS driver. JDBC URL FORMAT: jdbc:jtds:sqlserver://<host>:<port>/<database_name> The default port for Microsoft SQL Server is 1433. Usually, if the default port is being used by the database server, the :<port> value of the JDBC url can be omitted. Examples: jdbc:jtds:sqlserver://neptune.acme.com:1433/test jdbc:jtds:sqlserver://127.0.0.1:1433/test Microsoft SQL Server 2005 JDBC Driver DRIVER CLASS: com.microsoft.sqlserver.jdbc.SQLServerDriver DRIVER LOCATION: Specify the location on your machine of the Microsoft SQL Server driver. See your Microsoft SQL Server driver documentation for more details. Certain versions of the Microsoft SQL Server driver require more than one jar file for the driver location. In this case, simply separate each file location by a semi-colon. JDBC URL FORMAT: jdbc:sqlserver://<server_name>:<port> The default port for Microsoft SQL Server is 1433. Usually, if the default port is being used by the database server, the :<port> value of the JDBC url can be omitted. Examples: jdbc:sqlserver://neptune.acme.com:1433 jdbc:sqlserver://127.0.0.1:1433 Microsoft SQL Server JDBC Driver DRIVER CLASS: com.microsoft.jdbc.sqlserver.SQLServerDriver DRIVER LOCATION: Specify the location on your machine of the Microsoft SQL Server driver. See your Microsoft SQL Server driver documentation for more details. Certain versions of the Microsoft SQL Server driver require more than one jar file for the driver location. In this case, simply separate each file location by a semi-colon. JDBC URL FORMAT: jdbc:microsoft:sqlserver://<server_name>:<port> The default port for Microsoft SQL Server is 1433. Usually, if the default port is being used by the database server, the :<port> value of the JDBC url can be omitted. Examples: jdbc:microsoft:sqlserver://neptune.acme.com:1433 jdbc:microsoft:sqlserver://127.0.0.1:1433 |
