Download the 32-bit ODAC from Oracle.
Set up credentials in the "Security" page using Be made using this security context . 4. Troubleshooting and Best Practices Oracle's OLEDB Provider VS Microsoft ... - SQLServerCentral oracle oledb driver for sql server download
After installation, navigate to \network\admin within your installation folder. Download the 32-bit ODAC from Oracle