- Connecting using jTDS jdbc driver (open source)

Connecting using jTDS jdbc driver (open source)

The open source jTDS driver can be used to connect to SQL Server.

The connection properties that are unique to jTDS are the URL, Driver, User ID, and Password.

They must be exactly as follows:

• • URL - jdbc:jtds:sqlserver ://<server> [:<port>][/<database>]

    • (where server is your IP address, port is an optional port # (specify if not using the default), and database is the database)

  • JDBC Driver - jTDS SQL Server JDBC Driver (net.sourceforge.jtds.jdbc.Driver)

  • User ID - Any valid user ID

  • Password - Password for above User ID

NOTE: For connection properties and more details, see: http://jtds.sourceforge.net/faq.html

NOTE: You'll need to download the lastest jTDS jar from: http://jtds.sourceforge.net