C#에서 Oracle client를 설치하지 않고 접속하기

참조 URL
  1. http://www.thebestcsharpprogrammerintheworld.com/blogs/connect-to-an-oracle-database-without-an-oracle-client.aspx
  2. http://stackoverflow.com/questions/11366695/how-do-i-use-oracle-from-net
  3. http://www.sysnet.pe.kr/Default.aspx?mode=2&sub=0&detail=1&wid=822
  4. http://www.splinter.com.au/using-the-new-odpnet-to-access-oracle-from-c/
  5. http://www.splinter.com.au/connecting-to-oracle-from-c-winforms-aspnet-w/
  6. http://www.oracle.com/technetwork/database/windows/downloads/index.html

* oci.dll

* Oracle.DataAccess.dll

* oraociicus11.dll

* OraOps11w.dll

* orannzsbb11.dll

* oraocci11.dll

* ociw32.dll

 위 파일이 필요 하며 아래 코드와 같이 사용하면 된다.

[코드1] Oracle 연결 테스트

[코드2] Oracle 실행 테스트

관련 파일은 다음 링크에서 받을 수 있습니다.


Oracle Data Access Components and Tools - .NET and Windows

ODAC (32-bit)
ODAC (64-bit)

 자신의 버전에 맞게 클릭해서 들어 가면

Thank you for accepting the OTN License Agreement; you may now download this software.
64-bit ODAC 11.2 Release 5 ( Xcopy for Windows x64           [Released September 12, 2012]
 DownloadODAC1120320Xcopy_x64.zip - 55 MB (56,790,670 bytes)
  Installation Instructions are included within the zip file. 

Important: The 32-bit Oracle Developer Tools for Visual Studio download is required for Entity Framework design-time features. The above download fully supports Entity Framework deployment, but does not contain design-time tools.

Download Includes

  64-bit Oracle Data Provider for .NET 4
  64-bit Oracle Data Provider for .NET 2.0
  64-bit Oracle Providers for ASP.NET 4
  64-bit Oracle Providers for ASP.NET 2.0
  64-bit Oracle Provider for OLE DB
  64-bit Oracle Services for Microsoft Transaction Server
  64-bit Oracle Instant Client

위와 같은 화면이 눈에 보일것이다.

이 부분에서 ODAC1120320Xcopy_x64.zip를 다운받으면 관련 DLL들이 있을 것이다.

+ Recent posts