PRSQL9107018: BCP Calls Cause Data Conversion Errors

ID Number: Q75813

1.10

OS/2

buglist1.10 fixlist1.11 fixlist1.12

Summary:

Problem ID: PRSQL9107018

SYMPTOMS

When trying to bind 84 or more columns of a table with types of

char and datetime, and import the data via bcp_sendrow, the

following error message occurs:

Data-conversion resulted in overflow.

CAUSE

Any of the following problems caused this error:

1. The character fields were copied with their NULL terminators,

which used up more space than was available.

2. Empty datetime fields were rejected, instead of converted to the

default value.

3. Table adjustment values on the server page were incorrectly

calculated.

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.

Additional reference words: db-lib 1.10