Using Oracle ODP. Net 11g. Net Program release method)

Using Oracle ODP. Net 11g. Net Program release method ()

ODP. net 11g is released by Oracle for. netProgramThe ADO. NET component that accesses the Oracle database has better performance than the Oracle component that comes with Microsoft. It can also access advanced Oracle features such as the UDT (user defined type) type, procedure, and ref.

. NET 1.1 client requires the following release files:

• Oracle. dataaccess. dll (odt111 \ odp.net \ bin \ 1.x)
• Oraops11.dll (odt111 \ bin)

. NET 2.0 needs to be released:

• Oracle. dataaccess. dll (odt111 \ odp.net \ bin/2.0)
• Oraops11w. dll (odt111 \ bin)

The above clients all require OCI basic package support:

• OCI. dll
• Oraociei11.dll (it can also be replaced by a smaller oraociicus11.dll)
• Orannzsbb11.dll

To facilitate the test on the client, you can add the SQL * Plus package, which includes two files:

• Sqlplus.exe
• Orasqlplusic11.dll

To publish the sqlplus package, you can use sqlplus "user_name/password @ // 192.168.1.31: 1521/orcl" to test the Oracle status on the client.

According to the above principle, the minimum size of the ODP. Net Oracle client published files includes five files, and the size after compression is 8 MB:

• OCI. dll
• Oraociicus11.dll
• Orannzsbb11.dll
• Oracle. dataaccess. dll
• Oraops11.dll

For more information, see here:
Http://download.oracle.com/docs/cd/B28359_01/server.111/b31189/apd.htm
Http://forums.oracle.com/forums/thread.jspa? Threadid = 519176 & tstart = 0 & messageid = 2060399

And portal website:
Http://www.oracle.com/technology/tech/dotnet/index.html

 

Reprinted from: http://www.cnblogs.com/xugang/archive/2008/01/21/1047072.html