Use ODP. Net to connect to Oracle Web project release!

ODP. NET is the best method to connect. net to the Oracle database. For more information about ODP. net, see:

Http://www.oracle.com/technology/global/cn/tech/windows/odpnet/ODP.NET-FOV.html

: Http://www.oracle.com/technology/global/cn/software/tech/windows/odpnet/index.html

I used 9.2.

Web projects developed using ODP. NET are very simple to deploy. Oracle client does not need to be installed on the server. You only need to install ODP. net.

Then configure the data connection. This is a one-time success on Windows 2000. It is quite convenient for us to connect Oracle 9i and Oracle 8i databases.

In Windows 2003, the following error occurs during connection: "unable to load DLL (oraops9.dll)". In Chinese, the following error occurs: "unable to load DLL (oraops9.dll )", this is because Windows 2003 is more secure than 2000, and DLL cannot be read. solution:

Set the permission to the bin directory under the ODP. net installation directory to ASP. NET with read and write permissions, or assign the read and write permissions to everyone, remember, and restart the machine. In this way, you can access it.

This "unable to load DLL (oraops9.dll)" "cannot load DLL (oraops9.dll)" error will only be available under 2003, even if the Oracle client 9i client is installed, you must set the permission !!

Good luck !!