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

and http://social.msdn.microsoft.com/forums/vstudio/en-us/097ff93d-20be-41ed-b318-dc51cca0b811/the-specified-dsn-contains-an-architecture-mismatch-between-the-driver-and-application?forum=wcf

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

i read one: http://social.technet.microsoft.com/forums/sqlserver/en-us/a4ddb239-64d8-4074-978c-45c30381c107/ssrs-2012-error-im014-microsoftodbc-driver-manager-the-specified-dsn-contains-an-architecture?forum=sqlreportingservices

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

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

openid - Okta: Failed to get authorization code through API call -

thorough guide for profiling racket code -