No suitable driver

[Matt Dillion]

I've ran this before and I know it works. It's been awhile since I done some Java (I work in VB at work, and only get to use Java in my free time). Can anyone point out what went wrong? Did I change something that I shouldn't have?
Here's my output:
Getting driver sun.jdbc.odbc.JdbcOdbcDriver . . . Success.
Getting connection d:\Java\Nomey\data\Nomey.mdb . . . Failed.
No suitable driver

Here's my code:

package Java.Nomey.Jdbc;
import java.sql.*;
import java.util.*;
public class JDBConnection {
    protected String driver  = "sun.jdbc.odbc.JdbcOdbcDriver";
    protected String url, login, pwd;
    protected Connection con;

public static void main (String[] args) throws SQLException {
        JDBConnection conn = new JDBConnection ("sun.jdbc.odbc.JdbcOdbcDriver", url, "login", "pwd");
    }
    //Constructor
public JDBConnection (String driver, String url, String login, String pwd) {
        if(driver.equals(""))
            this.driver = driver;
        this.url = url;
        this.login = login;
        this.pwd = pwd;
        if(getDriver())
            getConnection();
    }
private boolean getDriver() {
        try {
            System.out.print("Getting driver " + driver + "...");
            Class.forName(driver);
            System.out.println("Success.");
            return true;
        } catch(java.lang.ClassNotFoundException e) {
            System.err.println("Failed.");
            System.err.println(e.getMessage());
            return false;
        }
    }
private boolean getConnection() {
        try {
            System.out.print("Getting connection " + url + "...");
            con = DriverManager.getConnection(url,login,pwd);
            System.out.println("Success.");
            return true;
        } catch(SQLException e) {
            System.err.println("Failed.");
            System.err.println(e.getMessage());
            return false;
        }
    }
}

Thanks for your help with a novice.
[ Edited by Dave to format code ]
[ June 11, 2002: Message edited by: David O'Meara ]

[lavanya subramanian]

Hi Matt,

try registering the driver atleast once before u attempt to get a connection before the class.forName()
DriverManager.registerDriver("your diver name");
i think this would help,
Lavanya

[Anonymous]

Hi
What is your URL?
The URL should be "jdbcdbc:<ODBC ALIAS>"

public class SimpleSearch {
   public static final void main (String args[]) {
      ResultSet r = null;
      try {
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      }
      catch (ClassNotFoundException cnfe) {
         System.err.println("JDBC-ODBC could not be found.");
      }
      try {                               // 'adresser' is the ODBC-datasource
         Connection c = DriverManager.getConnection("jdbc:odbc:adresser");
         Statement s = c.createStatement();
         r = s.executeQuery("SELECT * FROM myTabel WHERE navn = 'Mark';");
      }
      catch (SQLException se) {
         System.err.println(se.getMessage());
      }
      try {
         while (r.next()) {
           // some code
         }
      }
      catch(SQLException se) {
         System.err.println(se.getMessage());
      }
   }
}

/Rene
[ June 11, 2002: Message edited by: Rene Larsen ]