Trying the driver got this problem:
java.sql.SQLException: Failed to load database SBRF! For more information, please use SQLException.getNextException().
and get NextException shows:
java.sql.SQLException: An unkown encrypted Access database file
I think the external database is encripted for security but think some crypt should work (f.e. DES, TRIDES, or BLOWFISH) but allways got the same problem. I've tryed with other database created for my own and everybody works well. I could connect to the database from Wintel using java sun's JdbcOdbc bridge.
Any idea?
|
> I could connect to the database from Wintel using java sun's JdbcOdbc bridge.
Yeah. Now HXTT Access can't read an encrypted Access database file, if that file is encrypted by MS Access. DES, TRIDES, or BLOWFISH can be used to encrypt MS Access database, but is incompatible with MS Access. You need to use MS Access to decrypt your databse file, then HXTT Access can read/write normally that file.
|
Thanks, it's a really good driver. I've tested several conditions and everyone worked well. I'm really amused on how well did you read the MDB files even better than mdbtools on linux (odbc).
Are there any plans in near future to get this windows propietary encription mechanism integrated to the driver?
|
> how well did you read the MDB files even better than mdbtools on linux (odbc).
Because some of our programmers have good experiences on cracking Paradox database, and many variables of dbase database.
> Are there any plans in near future to get this windows propietary encription
> mechanism integrated to the driver?
Now Access can only read encrypted password from MS Access, and refuse to open a MS Access with password protection, if a correct password hasn't been set as Connection propetty. One programmer has checked and guessed the encryption mechanism is XOR with a very big key block, which is produced by an unknown algorithm. The encryption for Access 95(97)'s is simpler than that for Access 2000(2003). Maybe somedays we can provide such a function, if we can crack that unknown algorithm. Anyway, since MS Access' password is easily gotten, it's no bar to prohibit you to use MS Access to decrypt its database manually.
|