Hi Hany,

Did you try the suggested solution:

Enable "Allow inprocess" option in the Oracle Provider for OLE DB.

That resolves the issue.:-)