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.

Additional query words: dblib freeze gp-fault

Keywords          : kbprg SSrvCobol SSrvDB_Lib SSrvProg kbbug4.20 
Version           : 4.2 | 4.2 4.2a
Platform          : MS-DOS OS/2 
Issue type        : 

Last Reviewed: March 17, 1999