Monday, 15 February 2010

odbc - 64 bit java read write *dbf -



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