SSIS to Oracle “Could not create a managed connection manager.”

Eventually, I just had to remove the entries related to 11.1 in path variable then restarted my machine.

Also I switched to “dotConnectForOracle” for connection and now it seems to be working fine.

I’m expecting issues related to other applications that might still be using the 11.1 version, but that will be a problem for another day.

Always make sure to write the user (oracle schema) in uppercase and some special characters [in my case it was $] in the password needs escape character even if you’re using the wizard not the cmd

I still don’t understand the whole issue but I hope this helps someone some day.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top