Url format for jtds ??
843859Dec 14 2005 — edited Dec 15 2005Hi,
I want connect to my ms sql server database frm java.
i have download the jtds driver and put it on my classpath.
the driver documentation stated the below format :
jdbc:jtds:<server_type>://<server>[:<port>][<database>][;<property>=<value>[;...]]
wh
so i write my url like this :
url="jdbc:jtds:local://localhost:1433/ ";username="user ";password="password;";
But i get error msg...
java.sql.SQLException: The syntax of the connection URL 'jdbc:jtds:local://localhost:1433/northwind;username=sa;password=pass;' is invalid.
at net.sourceforge.jtds.jdbc.Driver.setupConnectProperties(Driver.java:239)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:175)
Can anyone help...?