CODEWITHSUNDEEP
oracle-databasevisual-studiovisual-studio-2015ssis
noobie
noobie

Reputation: 2607

SSIS visual studio 2015 oracle - Bad

Having issues connecting to Oracle (12c) using Visual Studio 2015 update 3 on Windows 10. I get the following error when testing the connection.

enter image description here

I need to connect using the .Net Providers and looking for advice/guidance on how to resolve the 32/64 bit issue.

I have followed this article Installing Oracle Data Provider for .NET and have managed to unzip the contents of the file to the c:\oracle directory and ran the batch file with the following parameters:

install_odpm.bat c:\oracle both false

The installation appears to run successfully, however, I still get the error in VS 2015.

I mostly use SQL server so not much experience troubleshooting Oracle connections.Any advice appreciated.

Upvotes: 1

Views: 437

Answers (1)

noobie
noobie

Reputation: 2607

I managed to resolve the issue. I followed these steps and it worked:

  1. Download and install both 32 and 64 bit clients from Client

  2. Download and install ODAC for Visual Studio 2015

Make sure visual studio 2015 is closed in the process.

Upvotes: 2

Related Questions