biddopa.blogg.se

1. #Oracle data access components for visual studio 2019 install
2. #Oracle data access components for visual studio 2019 software
3. #Oracle data access components for visual studio 2019 free

If you want to do local troubleshooting/development of SSIS, SSAS or SSRS objects on the server you will need to install both the 32 bit and 64 bit versions of the Oracle client.

#Oracle data access components for visual studio 2019 software

This software runs in 64 bit mode so if you do not install this on the server where the software is running you will get the "The OraOLEDB.Oracle.1 provider is not registered on the local machine" error when you execute your process on the server. Oracle Database Client for Microsoft Windows (圆4) - This is required for server side software such SQL Server Analysis Services, SQL Server Integration Services or SQL Server Reporting Services.You may be tempted to use 32-bit ODAC however since you are working on the server you will already have a 64-bit version of the Oracle client installed so you need to have a separate Oracle home for the 32-bit version of the client, the simplest way to do this is to use this client rather than the 32-bit ODAC. Oracle Database Client for Microsoft Windows (32-bit) - This is required if you are doing local troubleshooting of various MS objects such as SSIS, SSRS or SSAS on the server.As the name implies this is for 64 bit applications so be sure to check your applications to confirm they are running in 64 bit mode. Do not use this if you have any server software such as SQL Server installed on this computer. 64 bit Oracle Data Access Components - Use this if you only have 64 bit applications like Excel or Power BI.This is for 32 bit applications so be sure to check if Excel is 32 bit or 64 bit.

#Oracle data access components for visual studio 2019 free

In this post I will share some of the lessons that I have learned as well as provide some practical advice so that you can have a smooth, hassle free expereince when taking on this task.

Whether you are using Microsoft Power Pivot, SQL Server Analysis Services, Power BI, SharePoint Excel Services or the Change Data Capture Service for Oracle by Attunity it can be a confusing process to install and configure the required software to enable this functionality. Connecting to an Oracle database with various Microsoft (MS) products can be a challenge.