DSN-Less MSAccess connection issues

[Willy Ray]

Hey All, using the methods listed in this thread:

http://www.coderanch.com/t/405966/java/java/Trying-access-Microsoft-Access-java

I'm trying to create a dsn-less connection to an Access Database.

public Connection getConnection() throws Exception {
//String name = "C:\CompAnnotator\data\notes.mbd";
String name = "C:\\CompAnnotator\\data\notes.mdb";

String DB_URL_PREFIX = "jdbc :o dbc :D river={Microsoft Access Driver(*.mdb)};DBQ="; 
 
String DB_URL_SUFFIX = ";DriverID=22;READONLY=false}";
 
String url = DB_URL_PREFIX + name + DB_URL_SUFFIX;
 
System.out.println("A");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 
System.out.println("B");
Connection con = DriverManager.getConnection( url, "", "");
 
System.out.println("C");
return con;


}
 
    

I get down to "B", then I throw

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Any ideas?

/w
[ June 25, 2008: Message edited by: Willy Ray ]

[Willy Ray]

Oh, and when I do it like this (per the JavaRanch FAQ):

   
Connection con = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft} Access Driver (*.mdb);DBQ=C:/CompAnnotate/data/notes.mdb", "", ""); 
 

I get "java.sql.SQLException: General error"

/w

[Willy Ray]

Anybody?

/w

[Wei Dai]

Maybe you type wrongly.
>String name = "C:\\CompAnnotator\\data\notes.mdb";
Should be
String name = "C:\\CompAnnotator\\data\\notes.mdb";
You can try
A full dns-less url:
"jdbcdbcRIVER=Microsoft Access Driver (*.mdb); "
+"DBQ="+name+"; "
+"ImplicitCommitSync=Yes; "
+"UserCommitSync=Yes; "
+"Threads=3; "
+"SafeTransactions=0; "
+"PageTimeout=5; "
+"MaxScanRows=8; "
+"MaxBufferSize=2048; "
+"DriverId=281; "
+"DefaultDir=C:/Program Files/Common Files/ODBC/Data Sources"