IBM Support

Bit-version and ODBC connectivity with SPSS Statistics

Technote (FAQ)


Question

SPSS Statistics. How do different bit-versions (32-bit, 64-bit) for applications, operating systems, and ODBC drivers affect ODBC connectivity?

Cause

ODBC connectivity is bit-version dependent

Answer

The bit-version (32-bit, 64-bit) of all applications and ODBC drivers must be the same to affect connectivity. Connectivity failures arise on 64-bit operating systems when there is non-alignment between the bit-versions (32-bit, 64-bit) of the applications and ODBC drivers. Example: IBM SPSS Statistics 64-bit is installed on a 64-bit version of Microsoft Windows 7 operating system where a 32-bit version of Microsoft Access was installed. Attempts to establish connectivity between IBM SPSS Statistics 64-bit and Access 32-bit fails because the ODBC connection between the two applications cannot be both 32-bit and 64-bit at the same time. Furthermore, the bit-version (32-bit, 64-bit) of the applications and ODBC drivers must be the same. The only available remedy is to install applications with the same bit-version (32-bit, 64-bit) and use ODBC drivers corresponding to the bit-version (32-bit, 64-bit) of the applications. This issue is most frequently confronted on 64-bit Microsoft operating systems. Microsoft provides both 32-bit and 64-bit versions of ODBC on Microsoft 64-bit operating systems.

More information can be found within these Microsoft technical articles:

http://support.microsoft.com/kb/942976

AND

http://msdn.microsoft.com/en-us/library/ms712362(VS.85).aspx


Cross reference information
Segment Product Component Platform Version Edition
Business Analytics SPSS Amos Windows Not Applicable
Business Analytics SPSS Modeler Not Applicable Windows Not Applicable All Editions
Business Analytics SPSS Text Analytics Windows Not Applicable All Editions
Business Analytics SPSS Text Analytics for Surveys Windows Not Applicable All Editions

Document information

More support for: SPSS Statistics

Software version: Not Applicable

Operating system(s): Windows

Reference #: 1591777

Modified date: 2016-05-11