Find difficulty in connecting to sqlserver

[rejieve alexander]

Hi,
I'm kind of new to jdbc. And i'm facing a problem while making a connection with the sql server ie: to give a proper url.
When trying with ms-access i gave it as Connection con = DriverManger.getConnection("jdbcdbc:servData");where 'servData' is the dsn,and it works... but the same for the sqlserver it doesn't.Please help me in finding out the correct url for the sqlserver.. it's urgetn..
Thank you



[This message has been edited by rejieve alexander (edited October 18, 2001).]

[kim jungil]

did you configure your dsn? and when you create the connection the dsn is correct?

[rejieve alexander]

Hi kim,
This is my code
String url = "jdbc dbc:servData";
Connection con;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(url);
/*
where 'servData' is the dsn created for the sql server.
But the connection just isn't taking place..

*/