BUG: SQL Server Error "Specified column precision 38 is greater than the maximum precision of 28. (2750)" when Running Parameterized Query

ID: Q239725

The information in this article applies to:

Microsoft SQL Server version 7.0
Microsoft ODBC Driver for SQL Server, version 3.7

BUG #: 48147 (SQLBUG_70)

SYMPTOMS

You may get the following error message when you run a parameterized query against a SQL Server 7.0 database using the 3.70 driver:

Specified column precision 38 is greater than the maximum precision of 28. (2750)

CAUSE

The SQL ODBC driver uses a default value of 38 for the precision value if the application specifies SQL_DEFAULT for the precision when binding a decimal parameter. However, the default decimal precision on the server is 28.

WORKAROUND

Start SQL Server with a -P38 parameter to set the default server precision to 38.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords : kbODBC odbcSQL kbGrpMDAC kbGrpODBC
Version : WINDOWS:3.7; winnt:7.0
Platform : WINDOWS winnt
Issue type : kbbug