Ciao a tutti!
Qualcuno mi potrebbe aiutare con la seguente connessione di un Database Access:
Il codice in Java è seguente:
codice:
String path = new java.io.File("MotoriDataBase.accdb").getAbsolutePath();
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cn = DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+path);
st = cn.createStatement();
rs = st.executeQuery("SELECT * FROM Proprieta");
while(rs.next()){
System.out.println(rs.getString(1));
}
}catch(Exception ex){
ex.printStackTrace();
System.out.println(path);
}
Mi da un eccezione:
codice:
java.sql.SQLException: [Microsoft][????????? ????????? ODBC] ???????? ?????? ?? ?????? ? ?? ?????? ???????, ???????????? ?? ????????? at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at ImpostazioniFrame.conessioneDB(ImpostazioniFrame.java:43)
at ImpostazioniFrame.<init>(ImpostazioniFrame.java:21)
at ImpostazioniFrame.main(ImpostazioniFrame.java:33)
C:\Users\Yuliy.x.95\Documents\WorkSpace\Nice\MotoriDataBase.accdb