I have developed an ASP application on a WinXP box that draws data via OLEDB and ODBC from DB2, MS SQL and Oracle - works fine. When it was moved to a brand new ASP.NET Win2003 Server box, the Oracle connection did not worked.

We tried several different versions of the Oracle client, updating to MDAC 2.8, changing permissions on registry and files - all to no avail.

Does any one know how to access Oracle via IIS on Win 2003 Server???