September 7th, 2005, 04:19 PM
|
|
Registered User
|
|
Join Date: Sep 2005
Posts: 1
Time spent in forums: 15 m 8 sec
Reputation Power: 0
|
|
|
Problems connecting Access database
Please help!!
Can someone tell me what's wrong in my code? I can't connect to the database, i get the following messsage:
java.lang.NullPointerException
at javaapplication1.Main.main(Main.java:82)
Error connecting to db: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
The row (82) is:Statement st = conn.createStatement();
and the code:
Code:
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch(ClassNotFoundException e) {
System.out.println(e.toString());
}
String file = "C:/Java/JavaApplication1/Some.mdb";
//String url = "jdbc:odbc:Driver=MSADB;DBQ="+file;
String url = "jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ="+file;
Connection conn = null;
try {
conn = DriverManager.getConnection(url,"usr","psw");
conn = DriverManager.getConnection(url);
if (conn == null)
System.out.println("Driver failed - null Connection returned.");
else
System.out.println("-- Success");
}
catch(SQLException err) {
System.out.println("Error connecting to db: "+err.getMessage());
}
/*catch(ClassNotFoundException err) {
System.out.println("Error creating ODBC class: "+err.getMessage());
}*/
try
{
Statement st = conn.createStatement();
ResultSet set = st.executeQuery("Some SQL");
Last edited by MadCowDzz : September 8th, 2005 at 07:42 AM.
Reason: added [code] tags
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
