Re: SPSS 64bit / MS Access 32bit Driver incompatibility

Posted by Jignesh Sutar on Feb 24, 2015; 9:31pm
URL: http://spssx-discussion.165.s1.nabble.com/SPSS-64bit-MS-Access-32bit-Driver-incompatibility-tp5728796p5728798.html

The bitness have to be a match between SPSS and ODBC drivers ie MS Office. There are no workarounds (as far as I know). 

On Tuesday, 24 February 2015, Rick Oliver <[hidden email]> wrote:

Unfortunately, there may not be any easy way to resolve this, since the 32-bit Access driver doesn't play well with 64-bit applications. Microsoft has a 64-bit driver, but I don't think you can install it on a system running the 32-bit version of Access.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: <a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;[e-mail]&#39;);" target="_blank">oliverr@...



From:        MICHELLE WILSON <<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;[e-mail]&#39;);" target="_blank">mawasw@...>
To:        <a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;[e-mail]&#39;);" target="_blank">SPSSX-L@...
Date:        02/24/2015 02:15 PM
Subject:        SPSS 64bit / MS Access 32bit Driver incompatibility
Sent by:        "SPSSX(r) Discussion" <<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;[e-mail]&#39;);" target="_blank">SPSSX-L@...>

---

Hello,

I am using the 64 bit SPSS v22.  I am trying to use the Export to Database feature send my dataset to a table within my 32 bit version of MS Access.

The error message that I receive is ..........

Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed
Errors Found:
The specified DSN contains an architecture mismatch between the Driver and Application.

How can I resolve this?

Thanks,
Michelle
===================== To manage your subscription to SPSSX-L, send a message to <a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;[e-mail]&#39;);" target="_blank">LISTSERV@... (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
===================== To manage your subscription to SPSSX-L, send a message to <a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;[e-mail]&#39;);" target="_blank">LISTSERV@... (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD