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

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

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

using System; using Oracle.DataAccess.Client; namespace ClientTest { class Program { static void Main(string[] args) { //Oracle connectionstring string connectionString = "user id=USERID;password=PASSWORD;" + "data source=(DESCRIPTION=(ADDRESS="+ "(PROTOCOL=tcp)(HOST=IPorSERVERNAME)" + "(PORT=1521))(CONNECT_DATA=" + "(SERVICE_NAME=SID)))"; using (OracleConnection connection = new OracleConnection()) { connection.ConnectionString = connectionString; try { connection.Open(); Console.WriteLine("Connection Successful!"); Console.ReadLine(); } catch (OracleException ex) { Console.WriteLine(ex.ToString()); Console.ReadLine(); } } } } }

[코드1] Oracle 연결 테스트

using Oracle.DataAccess.Client; ... string connstring = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1527))" + "(CONNECT_DATA=(SID=mysid)));User Id=myuserid;Password=mypassword;"; using (OracleConnection conn = new OracleConnection(connstring)) { conn.Open(); string sql = "select * from dual"; using (OracleCommand comm = new OracleCommand(sql, conn)) { using (OracleDataReader rdr = comm.ExecuteReader()) { while (rdr.Read()) { Console.WriteLine(rdr.GetString(0)); } } } }

[코드2] Oracle 실행 테스트

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

http://www.oracle.com/technetwork/database/windows/downloads/index.html

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 (11.2.0.3.20) Xcopy for Windows x64           [Released September 12, 2012]       ODAC1120320Xcopy_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 11.2.0.3.0   64-bit Oracle Data Provider for .NET 2.0 11.2.0.3.0   64-bit Oracle Providers for ASP.NET 4 11.2.0.3.0   64-bit Oracle Providers for ASP.NET 2.0 11.2.0.3.0   64-bit Oracle Provider for OLE DB 11.2.0.3.0   64-bit Oracle Services for Microsoft Transaction Server 11.2.0.3.0   64-bit Oracle Instant Client 11.2.0.3.0

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

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