This week's book giveaway is in the OCAJP forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line! See this thread for details.
Steve, Database connection URLs are usually JDBC driver specific. I don't use SQL Server but I imagine that its compatible JDBC drivers have documentation which provide details of how to write a suitable one for your situation. Am I mistaken?
are you using sqlserver 2000 or 2005? connection varies for them, see the coed below. Get appropriate driver from microsoft site.
String connectionstring="jdbc:microsoft:sqlserver://nishanths:1433"; username="abc"; password="abcd"; //use any one of the line according to your sqlserver version //DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver()); //Use For SQL Server 2005
DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); //Use For SQL Server 2000 Con = DriverManager.getConnection(connectionstring,username,password);