SPSS Statistics. How do different bit-versions (32-bit, 64-bit) for applications, operating systems, and ODBC drivers affect ODBC connectivity?
ODBC connectivity is bit-version dependent
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:
|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|