All geek questions in one place

Oracle Instant Client with Web Application

I have a visual studio solution with an ASP.NET 3.5 web application (WCF host) and a test project. I wanted to use Oracle Instant Client (v11, via NHibernate) to create Oracle connections without installing a machine (dev, CI server, test server, production server) on the Oracle client tools on all the objects involved.

It is strange that on my development machine (x86) my tests run without problems, while my web application still gives me the following error message: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater

I have already ruled out:

  • The bin folder has read and execute permissions for everyone
  • DLL Unlocked (Windows 7)
  • The problem occurs with both Visual Studio Development Server and IIS 7
  • I also tested this on a machine with Oracle client tools installed, and it works

I even managed to run tests on our x64 CI server ( more ).

Does anyone know what I am missing?

+3
source share
1 answer

I see this error almost every time I install Oracle on a new machine.

  • Make sure the oracle bin folder is in your path.
  • Grant read and execute permission to everyone in the client folder (on my machine C: \ oracle \ product \ 10.2.0 \ client_1)
  • Changing permissions may not take effect until the computer restarts.

EDIT:

, 2 3 Oracle Instant Client. Hoverer, , , DLL Oracle Instant Client. DLL , .

http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html

:

  • Instant Client . Basic Basic Lite.

  • , "instantclient".

  • 2 ( "instantclient" ). UNIX LD_LIBRARY_PATH . Windows PATH.

  • .

+3

Source: https://habr.com/ru/post/1763466/

More articles:


All Articles