FreeTDS Development Group

["Mark Molenda" <mark.molenda AT eds.com>]

When I go to run a select on a SQL Server 6.5 I get the following message:

"SQLException: java.sql.SQLException: No suitable driver"


My code is as follows:
 try
 {
      Class.forName("com.internetcds.jdbc.tds.Driver");
 }catch(Exception ex)
  {
      System.out.println("Can't find Database driver class: " + ex);
      return;
  }
 try
 {
      String query2 = "select last_update from contact" ;
      Connection con2 =
DriverManager.getConnection("jdbc:freetds:goodhostnamehere","sa","password");

            

   Statement stmt2 = con2.createStatement();
   ResultSet rs2 = stmt2.executeQuery(query2);

etc...etc...

Does anyone out there have a fix for this?