Page 1 of 1

Using dotConnect in Azure WebApp

Posted: Fri 28 Oct 2016 15:47
by pkutakov
Hello,

We've created an application based on ASP.NET MVC, Entity Framework and BulkInsert package that was adopted for Oracle using dotConnect for Oracle driver (can be found here: https://github.com/Thorium/EntityFramework.BulkInsert). When we attempted to use it we got the following error:

Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server.

As you probably know there is no way to change IIS settings on Azure Web Site.

Is there any way to fix that?

Re: Using dotConnect in Azure WebApp

Posted: Tue 01 Nov 2016 14:09
by Pinturiccio
dotConnect for Oracle can establish a connection to Oracle database in two modes: Direct and OCI. If you use OCI, Oracle Client of the same bitness as your application is required to establish a connection. If your application is running as x64, Oracle Client x64 must be installed on the computer where your application is running. If your application is running as x86, Oracle Client x86 must be installed on the computer where your application is running.

If you cannot install Oracle Client of the required capacity on the computer where your application is running, you can use the Direct mode for establishing a connection without Oracle Client. For more information, please refer to https://www.devart.com/dotconnect/oracl ... tMode.html