Add a proper error message for ffi load

We call dlerror when a library failed to load properly.

Closes GH-9913.