Finding out the correct URL

[Neha Gap]

Hi Ranchers,

I am trying out this code..

public class DBAccess {
public static void main (String args[]) {

try {
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
java.sql.Driver d = (java.sql.Driver)Class.forName(driver).newInstance ();
String url = "jdbc:sqlserver://localhost:1433";
System.out.println(" Does this driver accept my URL? " + d.acceptsURL(url) );
Connection dbConn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433","sa","passwd");
Statement stm = dbConn.createStatement();
ResultSet rs = stm.executeQuery("select * from table1");
while(rs.next()) {
System.out.println(rs.getString(2));
System.out.println("---------------------");
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (Exception e) {
e.printStackTrace();
}
}
}

And this is the output at my console

Does this driver accept my URL? true
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at DBAccess.main(DBAccess.java:14)


Now, I know that the DriverManager accepts the given url, but it wont get a connection. How do I find out the correct URL, I'm using SQL Server 2005 Express edition. If possibly the username, password are incorrect, how can I reset the same?

Thanks!
Neha.

[Neha Gap]

Ok, well, made a silly mistake out there.
But now I'm getting the error

Does this driver accept my URL? true
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)


I've done everything to enable tcp/ip remote connections on my sql server, but it still gives me this error, besides, I cant even telnet localhost 1433. The etc/services file shows the port number is correct though.

Any idea how to get the thing to work with said port and url?

Thanks!
Neha.