How does 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 in order to effect 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. A 32-bit version of Microsoft Access has been installed. Any attempt to establish connectivity between IBM SPSS Statistics 64-bit and Access 32-bit will fail due to the fact that the ODBC connection between the two applications cannot be both 32-bit and 64-bit at the same time and 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.
For additional information see the following 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|