Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Url format for jtds ??

843859Dec 14 2005 — edited Dec 15 2005
Hi,
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...?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2006
Added on Dec 14 2005
5 comments
1,696 views