odbc - 64 bit java read write *dbf -
heya all,
i having issues , maybe has reply me!
i trying read write *dbf table java application. have found code :
try { class.forname("sun.jdbc.odbc.jdbcodbcdriver"); string connstring="jdbc:odbc:driver={microsoft dbase driver *.dbf)};defaultdir=c:\\test";//defaultdir indicates location of db connection connection=drivermanager.getconnection(connstring); string sql="select * table_name condition";// usual sql query statement stmt=connection.createstatement(); resultset resultset=stmt.executequery(sql); while(resultset.next()) { system.out.println(); } system.out.println(); } grab (classnotfoundexception e) { e.printstacktrace(); } grab (sqlexception e) { e.printstacktrace(); } this code working fine 32-bit version of windows when seek on 64 bit, gives me error :
[microsoft][odbc driver manager] info source name not found , no default driver specified
i have looked , best reply found playing dns in system32 or syswow64 wasent able threw or understanding no enough....
here link answer:
so reply found
thanks in advance...
i had same problem , solved uninstalling 64-bit version of jdk 6 , installing instead 32-bit one. application started work fine queries/updates on *.dbf files :)
hope helps!
java odbc 64bit dbf
No comments:
Post a Comment