Bit-version and ODBC

Technote (FAQ)


Question

How does 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 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:

http://support.microsoft.com/kb/942976
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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Statistics

Software version:

Not Applicable

Operating system(s):

Windows

Reference #:

1591777

Modified date:

2013-12-13

Translate my page

Machine Translation

Content navigation