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).]
Joined: Sep 27, 2001
did you configure your dsn? and when you create the connection the dsn is correct?
Joined: Dec 10, 2000
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..