Setting up IIS with System.Data.OracleClient

Question

Hi guys!

I have a asp.net web application that connects to a Oracle 10.2g database. If I'm running my site in the Visual Studio 2008 webserver everithing is ok, but when a publish it in IIS a get "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater".

I added all the permissions for the ASPNET, Authenticated Users and even Everyone but still doesn't work.

I have no idea what else to try. It seems clear to me that this is an IIS issue as the site works well in VS2008 integrated webserver. I'm using IIS 5.1.

Thanks in advance!

Answer 1

You have to install the Oracle client on your server. The DLL by itself is not enough.

Your database administrator should have the client install available. If not, it's available from otn.oracle.com