IBM Support

Bit-version and ODBC connectivity with IBM SPSS Statistics & Modeler

Technote (FAQ)


Question

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 IBM SPSS applications and ODBC drivers must match in order to connect successfully.

Application ODBC Drivers Database
SPSS Statistics & Modeler 64-bit 64-bit Drivers Can be 32 or 64 bit
SPSS Statistics & Modeler 32-bit 32-bit Drivers Can be 32 or 64 bit

If the application and ODBC drivers do not match, the connection will fail. Most versions of Microsoft Office products install 32-bit drivers. Office 2013 and up may provide both 32 & 64 bit drivers for certain products.

To check the bitness of the drivers you have installed, go to Control Panel->System and Security ->Administrative Tools->Data Sources (ODBC). In the ODBC Datasource Administrator Window, select the Drivers tab. Find the driver in question, and scroll to the right to the File column. The bitness is usually included in the file name (for example, the SQL driver file name might be SWLSRV32.DLL).

Once you understand your driver bitness, you must install the the application with the same bitness. If your driver is 32 bit, you must install the Statistics or Modeler 32-bit application. An alternative might be to review driver options on Microsoft's web page, to see if there are drivers compatible with your product.

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

Related information

Need more help? Our Statistics forum is Live!


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: 11 May 2016


Translate this page: