java - Windows 7 64, Eclipse 64, JDK 64 and specified DSN contains an architecture mismatch -
on windows 7 64 bit machine, eclipse kepler 64 bit, jdk6, have error:
sql error: java.sql.sqlexception: [microsoft][odbc driver manager] specified dsn contains architecture mismatch between driver , application 0 im014
this q&a unfortunately didn't me: https://stackoverflow.com/questions/6721702/windows-7-64-bit-odbc-drivers-for-ms-access-missing
"target" set to: %windir%\system32\odbcad32.exe
, "start in" set to: %windir%\system32
so, changed to: "target" to: %windir%\syswow64\odbcad32.exe
, "start in" set %windir%\syswow64
, later %windir%\system32
- didn't work neither way.
i had @ answer not satisfying (installing 32 bit version of java , sts) 64-bit java can't access 32-bit ms access database via odbc
i tried put argument "-d32" in vm arguments, didn't either.
neither one: is there windows 7 odbc driver access?
i read well: http://msdn.microsoft.com/en-us/library/ms712362(v=vs.85).aspx
but instructions visual studio, in eclipse kepler java se, don't know find options suggest (compiling options x86 vs. x64)
trying use architecture mismatch between driver , application? without success. when try install 64 bit drivers complains use 32 bit office , therefore drivers can't installed. installed 2007 office system driver: data connectivity components gained nothing weren't on system http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734
if understood properly, using windows 7 64 bit, eclipse kepler 64 bit, jdk6, , office access 2007, believe should using this:
quote: manage data source connects 32-bit driver under 64-bit platform, use c:\windows\syswow64\odbcad32.exe
what should in order make work (besides install 32 bit eclipse , 32 bit jvm op did here (64-bit java can't access 32-bit ms access database via odbc)
you can use 32-bit jre in 64 bit eclipse,
goto "window > preferences > java > installed jres", click "add"
then use new 32-bit jre target runtime "access" project (under "run configuration").
Comments
Post a Comment