Getting Oracle "hello world" LLBL project up

Posts   
 
    
ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 20-Oct-2020 22:11:20   

I'm a long time user of SQL Server + LLBL and have been tasked with creating an application with .Net EF 6 and Oracle.

I have installed the ODP.Net (I think?) but when I try to use the designer for Oracle ODP.Net I get:

Exception message:

Exception type: ArgumentException Unable to find the requested .Net Framework Data Provider. It may not be installed.

***Installation of ODP.Net ***

` PS C:\oracle> .\install_odpm.bat c:\oracle x64

reg add "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application\Oracle Data Provider for .NET, Managed Driver" /v EventMessageFile /t REG_EXPAND_SZ /d C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319\EventLogMessages.dll /f The operation completed successfully.

reg query HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft.NETFramework\v4.0.30319\AssemblyFoldersEx\odp.net.managed\

reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft.NETFramework\v4.0.30319\AssemblyFoldersEx\Oracle.ManagedDataAccess" /ve /t REG_SZ /d c:\Oracle\odp.net\managed\x64..\common /f The operation completed successfully.

reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft.NETFramework\v4.0.30319\AssemblyFoldersEx\Oracle.ManagedDataAccess.EntityFramework6" /ve /t REG_SZ /d c:\Oracle\odp.net\managed\x64..\common\EF6 /f The operation completed successfully. PS C:\oracle>

`

Attachments
Filename File size Added on Approval
2020-10-20_13-12-15.jpg 243,791 20-Oct-2020 22:12.42 Approved
ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 20-Oct-2020 22:21:25   

Fixed.

Step 1: Download the 64Bit ODAC XCopy from https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html

Step 2: Unzip to c:\oracle

Step 3: I needed to run this install:

C:\oracle> .\install_odpm.bat c:\oracle x64 true

Then reboot

Then it worked