Monday, March 1, 2010

jTDS info

After having looked up the hundredth time, I put this here so I find it easily:

What is the URL format used by jTDS?
The URL format for jTDS is:
jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]

where is one of either 'sqlserver' or 'sybase' (their meaning is quite obvious), is the port the database server is listening to (default is 1433 for SQL Server and 7100 for Sybase) and is the database name -- JDBC term: catalog -- (if not specified, the user's default database is used)

Original: http://jtds.sourceforge.net/faq.html#urlFormat