BUG: SQLSetPos(SQL_ADD) Error 2750 on Keyset Cursor

• Microsoft SQL Server, version 6.0

SYMPTOMS

If a client computer running the Japanese version of Windows NT attempts a SQLSetPos(SQL_ADD) on a keyset cursor, the Microsoft SQL Server ODBC Driver may incorrectly generate the following error:

   SQLState = 37000, pfNative =  2750
   szErrorMsg = '[Microsoft][ODBC SQL Server Driver][SQL Server]
                 Column or parameter #5: -- specified column
     precision 49 is greater than the maximum precision
     of 38.'

STATUS

Microsoft has confirmed this to be a problem in the Microsoft SQL Server ODBC Driver version 2.50.0126. The problem does not occur in version 2.65.0201 of the driver.

WORKAROUND

Insert the row using an insert command, or use forward only cursors.

MORE INFORMATION

Some 2750 errors returned on a SQLSetPos will be valid if the application has specified a precision on SQLBindCol that is larger than that supported by the associated column in SQL Server. However, in some cases on Japanese clients this error may be raised incorrectly. The problem is specific to the 2.50.0126 driver that ships with SQL Server Service Packs 1 and 2. It does not occur on the 2.50.0121 driver that ships with SQL Server 6.0, or with the 2.65.0201 driver that ships with SQL Server 6.5.