Hi,
I am using Oracle2Access V1.2 API for connecting to the MDB file from my JAVA application. But i am getting an error
java.sql.SQLException: D:/tempDB.mdb; doesn't exist or can't be accessed!
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.access.n.(Unknown Source)
at com.hxtt.sql.access.EmbeddedDriver.connect(Unknown Source)
at com.hxtt.global.SQLState.getConnection(Unknown Source)
at com.hxtt.sql.HxttDriver.if(Unknown Source)
at com.hxtt.sql.HxttDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at dc.ImportOracleData.(ImportOracleData.java:41)
at dc.ImportOracleData.main(ImportOracleData.java:153)
The database is in D:\ drive (D:\tempDB.mdb) which is same i have given in the application. But i am getting the above mentioned error.
Please help me to sort this out
|
Please redownload the EMBOracle2Access_WithDRV.jar package or EMBOracle2Access_WithoutDRV.jar package.
We have fixed this problem.
You can run the follows test sample code to export data.
public static void main(String[] args) throws SQLException, ClassNotFoundException, InstantiationException, IllegalAccessException {
//exportTableToAccess2003(String schemaName, String tableName, String targetDirectory, String targetTableName, String targetConnPar) throws SQLException {
Connection aConn = null;
try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
aConn = DriverManager.getConnection("jdbc:oracle:thin:test/test@192.168.1.16:1521:testdb");
com.hxtt.data.export.advance.OracleConnectionGetter.setConnection(aConn);
com.hxtt.data.export.advance.Oracle2Access.exportTableToAccess2000(null,"kf_csb","h:/tmp/new.mdb","BTABLE",null);
//must recall setConnection function
com.hxtt.data.export.advance.OracleConnectionGetter.setConnection(aConn);
com.hxtt.data.export.advance.Oracle2Access.exportTableToAccess2000(null,"kf_ggtc","h:/tmp/new.mdb","KF_GGTC",null);
}
catch(Exception ee ) {
ee.printStackTrace();
if (aConn!=null) aConn.close();
}
}
|
If this errors happened still, maybe the Access MDB file has damaged or be a unsupported mdb format.
Please sent your tempDB.mdb file to our email box.
|