.NET

odp.net 4.0 을 수동으로 설치시, client 경로 지정하기

김모작자 2013. 8. 13. 11:41

http://docs.oracle.com/html/E10927_01/InstallODP.htm

--------------------

위 링크에 내용 있음...

결론은

1) web.config 등에 사용할 oracle (instant) client 를 지정할 수 있음

2) registry (HKLM/Software/Oracle/ODP.net 에 경로를 써도 된다

----------------------

1) 링크에 있는 내용 발췌 - config 파일에 경로 지정하기

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <oracle.dataaccess.client>
    <add key="DllPath"            value="C:\oracle\bin"/>
    <add key="FetchSize"          value="65536"/>
    <add key="StatementCacheSize" value="10"/>
    <add key="TraceFileName"      value="c:\odpnet1.trc"/>
    <add key="TraceLevel"         value="63"/>
    <add key="TraceOption"        value="1"/>
  </oracle.dataaccess.client>
</configuration>

The following is an example of a web.config file for .NET Framework 2.0:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <oracle.dataaccess.client>
    <settings>
      <add name="DllPath"               value="C:\oracle\bin"/>
      <add name="FetchSize"             value="65536"/>
      <add name="PromotableTransaction" value="promotable"/>
      <add name="StatementCacheSize"    value="10"/>
      <add name="TraceFileName"         value="C:\odpnet2.trc"/>
      <add name="TraceLevel"            value="63"/>
      <add name="TraceOption"           value="1"/>
    </settings>
  </oracle.dataaccess.client>
</configuration>