Can anyone tell me how the source
code to create a dsn-less connection to a Microsoft
Access 2000 database called "Test" (using the source
code rather than the control panel to setup the
database).So far I have found this code, it compiles but when
I run it I get the following error
message:Connection Exception: java.sql.SQLException:
[Microsoft][ODBC Microsoft Access Driver] Could not find file
'(unknown)'.Could anyone tell me whats wrong and how to fix it
please.-----------------------Code:import
java.sql.*;public class
MakingTheConnection3 { public static void main(String[] args)
{Connection connection; Statement statement; String
url = System.getProperty("user.dir") +
"\\catalogo.mdb"; String conStr = "jdbc:odbc:Driver={Microsoft
Access Driver (*.mdb)};DBQ=" + url; try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connection =
DriverManager.getConnection(conStr); connection.createStatement(); }
catch
(Exception ex){ System.out.println("Connection
Exception: " + ex); } }}