BUG: SQL Server Error "Specified Column Precision 38 Is Greater Than the Maximum Precision of 28. (2750)" When Running Parameterized Query

When you run a parameterized query, with a parameter of type decimal and a precision of 38, against a SQL Server 7.0 database using the 3.70 driver, you may receive the following error message:

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 SQL Server is 28.

To work around this problem, start SQL Server with a -p38 parameter to set the default server precision to 38.

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

Steps to Reproduce Problem

1. Cut and paste the following code into SQL Query Analyzer:

     CREATE TABLE [dbo].[abcd] (
   	[a] [int] NULL ,
   	[b] [datetime] NULL ,
   	[c] [decimal](18, 5) NULL ,
   	[d] [int] NULL 
   ) ON [PRIMARY]
   GO
   					

2. Attempt to execute the following:

   create proc #odbc#efwadm19151b(@P1 int,@P2 decimal(38,5),@P3 int) as  INSERT INTO abcd( a, b, c, d) VALUES (@P1, getdate() ,@P2,@P3)