Visual Studio 2019 Professional: Installing Oracle Data Access Components (ODAC) with Oracle Developer Tools

Ambar Prajapati
3 min readFeb 18, 2020

--

Please Note: Below installation is not supported on Visual Studio 2019 Community Edition.

The design-time features under Visual Studio 2019 are available only when you install the 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio.
You can download the above installer ODTwithODAC122011.zip from here.

Running the installer will present the following sequence:

Specify Oracle Home User.
I will prefer to keep it as — Use Windows Built-In Account.

Specify Installation Location
Again I will go with the defaults

Available Product Components

Please note: If you are using an unsupported version of Visual Studio, then there will be an error on the next step and the installation will cease.

I will keep the below checkbox unchecked, because I would want to use a Nuget package for Oracle Data Access Components.

On the next DB Connection Configuration page:
Host name is the name of your system. You can also get the hostname by executing the command hostname on windows command-line.

After performing the requisite checks, the below summary page is shown.

Next hit Install to get going.

And finally the success page:

Congratulations. You got it right!!

--

--