Dy medley assamese mp3 songs free download songs. Connect to an Oracle database • • 2 minutes to read • Contributors • • • • • • In this article In order to connect to an Oracle database with Power BI Desktop, the correct Oracle client software must be installed on the computer running Power BI Desktop. Which Oracle client software you use depends on which version of Power BI Desktop you have installed - the 32-bit version or the 64-bit version. Supported versions: Oracle 9 and later, Oracle client software 8.1.7 and later.

Our application is built and packaged with oracle 11g Oracle.DataAccess.dll and in the same box we have installed 12.2 Oracle Client (No other oracle client is installed). The Oracle server is running on 12.2 version. Now, when we are installing our product, it is trying to communicate to Oracle Server via the client.

Determining which version of Power BI Desktop is installed To determine which version of Power BI Desktop is installed, select File > Help > About then check the Version: line. In the following image, a 64-bit version of Power BI Desktop is installed: Installing the Oracle client For 32-bit versions of Power BI Desktop, use the following link to download and install the 32-bit Oracle client: • For 64-bit versions of Power BI Desktop, use the following link to download and install the 64-bit Oracle client: • Connect to an Oracle database Once the matching Oracle client driver is installed, you can connect to an Oracle database. To make the connection, take the following steps: • From the Get Data window, select Database > Oracle Database • In the Oracle Database dialog that appears, provide the name of the server, and select Connect. If a SID is required, you can specify that using the format: ServerName/SID, where SID is the unique name of the database. If the ServerName/SID format doesn't work, try using ServerName/ServiceName, where ServiceName is the alias used when connecting.

Tip If you're having trouble connecting in this step, try using the following format in the Server Name field: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=port_num))(CONNECT_DATA=(SERVICE_NAME=service_name))) • If you want to import data using a native database query, you can put your query in the SQL Statement box, available by expanding the Advanced options section of the Oracle Database dialog. • Once your Oracle database information is entered into the Oracle Database dialog (including any optional information such as a SID or a native database query), select OK to connect. • If the Oracle database requires database user credentials, input those credentials in the dialog when prompted. Troubleshooting If you downloaded Power BI Desktop from the Microsoft Store, you might be unable to connect to Oracle databases because of an Oracle driver issue. If you encounter this issue, the error message returned is 'Object reference not set'. To address the issue, do one of the following: • Download Power BI Desktop from instead. • If you want to use the version from the Microsoft Store: on your local computer, copy oraons.dll from 12.X.X client_X into 12.X.X client_X bin.

The X represents version and directory numbers.

I've recently set up a Windows 8.1 64 Bit Machine with Visual Studio 2013 (probably 32 bit, at least it installed itself at Program Files (x86)). I've also installed the Oracle 11.2.0.1 64 Bit Client with Oracle Data Provider for.NET.

When I do gacutil /l findstr Oracle.DataAccess, I get four entries, including the following: Oracle.DataAccess, Version=2.112.1.0., processorArchitecture=AMD64 However, I cannot find Oracle.DataAccess in any of the lists when trying to add an assembly (Oracle.Web is present under Assemblies->Extensions, though). Do I have to install the 32 bit Oracle Client (or simply 32 bit ODP.NET) as Visual Studio is 32 bit? If so, will the software be able to run on a 64 bit system with a 64 bit application and 64 bit Oracle Client (with 64 bit ODP.NET)? Yes, Visual Studio is an 32bit application. It depends on your compilation target ( x86 or x64 or AnyCPU) which Oracle Client you need for running/debugging your application, regardless of the architecture from Visual Studio. AnyCPU will run as 64 bit on a 64 bit Windows (which is most likely the case) Oracle.DataAccess does not appear because it is an 64bit assembly but your Visual Studio is 32bit. There are several solutions: • In Add References use the Browse section and locate Oracle.DataAccess.dll manually.