MS SQL Connection (Local Server)

[skaa]

How to connect to local sever through JDBC?
I try:
DriverManager.getConnection("jdbc:microsoft:sqlserver://(local);databasename=Test","sa","");
, but have the Exception
[Microsoft][SQLServer JDBC Driver]Unable to connect. Invalid URL.
Thanx!

[ngpgeeta]

What I have understood you have to connect to database test of SQL server.

First try to make a driver with SQLServer using odbc data sources (32 bit) of your systems control panel. In that, in system dsn, make a driver for sql server. Connect your database test with that driver.
Once you have made a driver with test database, in your coding write

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn= DriverManager.getConnection("jdbc:odbc:test","sa","");

Hope this helps!

[skaa]

Thank you! It helped.