SAS with BULKLOAD=Yes: ERROR: BCP initialize error: Unable to retrieve error message

bulk-load sas sqlbulkcopy

Question

Has anyone encountered the error when trying to run in any of the bulk modes (not just bulkload=yes, but also insertbuff=xxx etc). The related odbcbcp.dll is present in the System32 directory, so this is not the case of being unable to find it.

Runs fine w/out bulk load, but of course the speed is not even close.

SAS 9.3, Win 32-bit

Popular Answer

Okay, with some most random luck, discovered that this may have been a bug specifically in sas 9.3, which has been subsequently eliminated in v9.4

Still an open question for those of us locked in v9.3 due to licensing.




Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why