Here comes one of those puzzling errors that can have you spinning your wheels for a bit until you resolve it. Just recently, I was helping a client building a Fixed Assets integration.
See more here:
IM – Cannot Open Database error when running eConnect adapter integration