I'm a bit confused why you can download the older 10g for both x86 and x64, but for 11g you can only download the x86 (32-bit) one. Thanks for any clarification you can provide. Installing Oracle ODBC Driver to Windows 2012 Server R2 January 24, 2016 Haneef Puttur ASP.Net, Oracle, Windows Step1: Download 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio. Odac Software - Free Download odac - Top 4 Download - Top4Download.com offers free. software downloads for Windows, Mac, iOS and Android computers and mobile devices. Visit for free, full and secured software’s. Odac Software - Free Download odac - Top 4 Download. Link to us; Tell-a-friend. And FreeBSD for both 32-bit and 64-bit platforms. Oracle 10g Free Download. Click on below button to start Oracle 10g Free Download. This is complete offline installer and standalone setup for Oracle 10g. This would be compatible with both 32 bit and 64 bit windows.
- Oracle 10g Odac 32 Bit Download
- Oracle 10g 32 Bit Download
- Odac 10g 32 Bit Download Windows 7
- 32-bit Download For Windows 7
- Odac 10g 64 Bit Download
- ODAC 12r3 beta2 32-bit xcopy deployment & EF6 I've tried to use EF6.1.1 together with xcopy deployed managed ODAC driver. EF complains it cannot find the provider with invariant name 'Oracle.ManagedDataAccess.Client', even though i added it to my App.Config. (also checked version numbe.
- Hello, I am trying to install Oracle Data Access Components (ODAC) for Windows 32-bit Release 10.2.0.2.21 on a machine with Windows Server 2008 64 bit. I have gone through the installation.
-->
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.
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.TipIf 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 https://powerbi.microsoft.com/desktop instead.
- If you want to use the version from the Microsoft Store: on your local computer, copy oraons.dll from 12.X.Xclient_X into 12.X.Xclient_Xbin. The X represents version and directory numbers.
-0001-11-30 Views:7
I've tried to use EF6.1.1 together with xcopy deployed managed ODAC driver. EF complains it cannot find the provider with invariant name 'Oracle.ManagedDataAccess.Client', even though i added it to my App.Config. (also checked version number and
I've tried to use EF6.1.1 together with xcopy deployed managed ODAC driver. EF complains it cannot find the provider with invariant name 'Oracle.ManagedDataAccess.Client', even though i added it to my App.Config. (also checked version number and public key token).
After installing the non-xcopy client on my system it all works, this is no problem for my development system, but i don't want to do this for the actual client pcs later.
please make sure we can use xcopy-deployment together with entity framework.
After installing the non-xcopy client on my system it all works, this is no problem for my development system, but i don't want to do this for the actual client pcs later.
please make sure we can use xcopy-deployment together with entity framework.
Advertisement
Yes, i did rebuild the solution (even closed VS2012, cleaned and rebuild).My complete App.Config looks like this:
<?xml version='1.0' encoding='utf-8' ?>
<configuration>
<configSections>
<section name='entityFramework' type='System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' requirePermission='false' />
</configSections>
<startup>
<supportedRuntime version='v4.0' sku='.NETFramework,Version=v4.5' />
</startup>
<entityFramework>
<providers>
<provider invariantName='Oracle.ManagedDataAccess.Client' type='Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, Oracle.ManagedDataAccess.EntityFramework, Version=6.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342' />
</providers>
Oracle 10g Odac 32 Bit Download
</entityFramework>
</configuration>
Oracle 10g 32 Bit Download
other things maybe relevant:- there was an oracle 11g client installed on my system
Odac 10g 32 Bit Download Windows 7
- i had a class derived from DbConfiguration in my project with SqlProviderServices('Oracle.ManagedDataAccess.Client', EFOracleProviderServices.Instance); in the constructor