ACC2000: "Error 3701: 'Invalid Scale for Decimal Datatype'" Error Message When You Try to Link an Informix Table to an Access Database (319485)

SYMPTOMS

When you try to link an Informix table to a Microsoft Access database, you may receive the following error message:

Error 3701 "Invalid scale for decimal datatype."

CAUSE

This issue may occur if the following two conditions are true:

The Informix table contains fields with the Decimal (16,0) datatype.

-and-
You use an outdated version of the Informix Open Database Connectivity (ODBC) driver.

RESOLUTION

To resolve this issue, upgrade the Informix ODBC driver. To do this, follow these steps:

Download and install the most current Informix ODBC driver. For more information, visit the following Informix Web site:

http://www.informix.com

You can also download an evaluation copy of a similar driver from DataDirect Technologies. For more information, visit the following DataDirect Technologies Web site:

http://www.datadirect-technologies.com/odbc/connectodbc/opxconnectodbc.asp
Download and install the most current version of Microsoft Data Access Components (MDAC). To do this, visit the following Microsoft Universal Data Access Web site:

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp
Create a System DSN to use the new ODBC driver.
Link the Informix database table to your database.

MORE INFORMATION

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.