PRSQL9107017: Text Data Incorrectly Inserted into SQL Server

ID Number: Q75812

1.10

OS/2

buglist1.10 fixlist1.11

Summary:

Problem ID: PRSQL9107017

SYMPTOMS

Deleting text data from a table that was loaded with a default of

NULL via bcp_bind() and bcp_sendrow() gives the following error

message:

Attempt to fetch logical page ) in database 'pubs' belongs to

object 'ALLOCATION' not object 'booboo'

(Msg 605, Level 21, State 1).

The SQL server is terminating this process.

(Msg 5702, Level 0, State 1).

CAUSE

Data that should not be loaded is loaded after the bcp_sendrow()

call fails because the PREFIXLEN parameter of bcp_bind() was not

set to 0 (zero).

RESOLUTION

Microsoft has confirmed this to be a problem in DB-LIBRARY (dblib)

version 1.1. This problem has been corrected in DB-LIBRARY version

1.12, which is available from Microsoft Product Support Services.

For more information, contact your primary support provider.