No Suitable Driver Error

[Steve Dyke]

This is my class. I get error No Suitable Driver. Please help:

 
public class WinpakConnection {
 
public WinpakConnection(){

}

public void setWPConn(){

try{
//Get connection
    DriverManager.registerDriver(new
    com.microsoft.sqlserver.jdbc.SQLServerDriver());
    Connection connection = DriverManager.getConnection(
    "jdbc:microsoft:sqlserver://GVSECSVR1:1433","***","***");
    if (connection != null) {
     System.out.println();
      System.out.println("Successfully connected");
      System.out.println();
      // Meta data
      DatabaseMetaData meta = connection.getMetaData();
      System.out.println("\nDriver Information");
      System.out.println("Driver Name: "
       + meta.getDriverName());
      System.out.println("Driver Version: "
       + meta.getDriverVersion());
      System.out.println("\nDatabase Information ");
      System.out.println("Database Name: "
       + meta.getDatabaseProductName());
      System.out.println("Database Version: "+
      meta.getDatabaseProductVersion());
    }
}
catch(SQLException sqle){
System.out.println(sqle);
}
 
}

}
 

[Ulf Dittmer]

I think the ":microsoft" in the connection URL is superfluous; try "jdbc:sqlserver:" instead.

By the way, it's much more common not to instantiate the driver directly, but to do something like:

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver")

That also makes it easy to keep driver class name and connection url details in an external data source, instead of hardcoding them.

[Steve Dyke]

Now I get a message: Unknown Source

[Avi Abrami]

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?

Just did a Google search and came up with this:

http://support.microsoft.com/kb/313100

Maybe it will help you?

Good Luck,
Avi.

[Nishanth Sivaraman]

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);


Thanks,

Nishanth.S