PRSQL9109004: Using bcp_sendrow() with Multiple Bit Columns

ID Number: Q76407

1.11 | 1.11 | 1.11

MS-DOS | WINDOWS | OS/2

buglist1.17

Summary:

Problem ID: PRSQL9109004

SYMPTOMS

Using bcp_sendrow() to send one row with multiple (two or more) bit

columns causes all but the first bit column to be set to 0 (zero).

CAUSE

SQL Server packs multiple bit fields into a single byte. DB-LIBRARY

(dblib) does not properly pack multiple bit columns before they are

sent to SQL Server.

STATUS

Microsoft has confirmed this to be a problem in DB-LIBRARY version

1.17. Microsoft is researching this problem and will post new

information here as it becomes available.

Additional reference words: db-lib