Error connecting jdbc with SQL server

Hi,

I get the following error when I try to run a sample program to connect SQLserver with JDBC . The driver I used to connect is " com.microsoft.jdbc.sqlserver.SQLServerDriver ".

I have registered the driver properly but have problem in connecting to JDBC.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source

)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at Test.main(Test.java:12)

pls help

Thanks in advance

[824 byte] By [boxera] at [2007-11-26 17:49:04]
# 1
Well there is something wrong with your database URL you are giving to the driver. You should lookup the documentation for the driver and see what format the URL should be in.Here is an open source driver you could try too -- http://jtds.sourceforge.net/
den2681a at 2007-7-9 5:01:32 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...