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