BUG: Dbcursorbind with Money Datatype May Hang Application

• Microsoft SQL Server Programmer's Toolkit, version 4.2

SYMPTOMS

When a C function, using DB-Library (DB-Lib) cursors and doing a dbcursorbind of a money column to a C string variable, is called from a COBOL application, the application may hang (stop responding). On MS-DOS programs, if enough time is allowed to pass, the machine may restart itself. For OS/2 programs, if enough time is allowed to pass, the program may experience a general protection fault (GP fault). When the C function is called from a C program, the function works fine.

WORKAROUND

Instead of using dbcursorbind to bind the money column to a program variable, use dbcursorbing with a vartype of NOBIND on the money columns and use dbconvert to convert the data from money to string.

STATUS

Microsoft has confirmed this to be a problem in DB-Library version 4.20.00. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.