Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VS 2019 and ODT 2019: Could not create a managed connection manager.

4206949Mar 8 2020 — edited Apr 21 2020

I am trying to establish a connection to an Oracle database from Visual Studio 2019 by using the new

ODT for Visual Studio 2019, I also have Oracle Client 12g 32 Bit.

VS2019 Run64BitRuntime = False

I am able to connect in design mode and view both fields and preview data without issue, but I receive the following error when I run in debug mode.

Information: 0x4004300A SSIS.Pipeline: Validation phase is beginning.

Error: 0xC0208449: ADO NET Source has failed to acquire the connection {597BE085-845A-4F05-B11A-04CAF97F0554} with the following error message: "Could not create a managed connection manager.".

Error: 0xC0047017 SSIS.Pipeline: failed validation and returned error code 0xC0208449.

Error: 0xC004700C SSIS.Pipeline: One or more component failed validation.

Error: 0xC0024107 There were errors during task validation.

I really appreciate if someone could help.

Added on Mar 8 2020

#oracle-developer-tools-for-visual-studio

4 comments

5,860 views