PRSQL9106010: Cannot Insert NULL Datetime with BCP DB-LIBRARYS

ID Number: Q73557

1.10

OS/2

buglist1.10 fixlist1.16

Summary:

Problem ID: PRSQL9106010

SYMPTOMS

Page 205 of the "Microsoft SQL Server Programmer's Reference for C"

correctly states that when you call bcp_bind with the <varlen>

parameter equal to 0 (zero), the value will be inserted as a NULL when

bcp_sendrow is called. This is not the case with datetime values in

DB-LIBRARY (dblib) version 1.14. Instead of a NULL value being

inserted, the date "Jan 1 1900 12:00AM" is inserted. DB-LIBRARY

version 1.11 works correctly.

RESOLUTION

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

1.1. This problem was corrected in DB-LIBRARY version 1.16, which

is available from Microsoft Product Support Services. For more

information, please contact your primary support provider.