IBM Support

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

Question & Answer


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 (Consult database vendor)
SPSS Statistics & Modeler 32-bit 32-bit Drivers Can be 32 or 64 bit (Consult database vendor)

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 bit-version 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 bit-version is usually included in the file name (for example, the SQL driver file name might be SWLSRV32.DLL).

Once you understand your driver bit-version, you must install the the application with the same bit-version. 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

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Not Applicable","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSLVC7","label":"IBM SPSS Amos"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Not Applicable","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS3RA7","label":"IBM SPSS Modeler"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Not Applicable","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS6A7K","label":"IBM SPSS Text Analytics for Surveys"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Not Applicable","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 August 2022

UID

swg21591777

Page Feedback