Hi All
well, this is the first for me to try making connection between
java and databases using MSAccess.
1. first of all I downloaded jdk1.3.1 and Fortee for java, release 2.0 in order to , before starting real work, try an example.
2. I've changed my path to be c:\jdk1.3.1\bin.
3. created the microsoft access application.
4.tried this very simple example :
import java.sql.*;
public class CreateCoffees extends Object {
public static void main (
String args[]) {
String url = "jdbc
dbc:CAFEJAVA";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ex){
System.err.println("ClassNotFoundException: ");
System.err.println(ex.toString());
}
try{
Connection con = DriverManager.getConnection(url);
}
catch (SQLException s){
System.err.println("SQL Exception: ");
System.err.println(s.toString());
}
}
}
after I run the code the following run time error appears:
SQL Exception:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
