In our old solution we used db-library for bulk copy feature:
bcp_bind(pDBProc, (LPCBYTE) lpVarAdress, 0, nLength,
(LPCBYTE) lpszTerminator, nTerminatorLength, nType, nColumn)
The value for each parameter used are:
pdbprocess structure, lpVARAdress=NULL(""), nLength = -1,lpszTerminator = "",nTerminatorLength=0,nType=52.
This is running fine with db-library api for the same table, I have migrated the solution to SQL server native client API, and while running this API it is giving me error as
"[Microsoft][SQL Native Client]Attempt to bulk-copy a NULL value into a Server column which does not accept NULL values"
My concern is why the same parameters are running fine with db-library api,table is same no change in column strucutre. HOw can we achieve the same with SQL server native client
Cheers!!! Vatsa www.objectiveprogramming.com
View Complete Post