Problem deploying .net web app\Oracle 10g

I am trying to deploy a .NET Oracle web application developed in VS2005 to a customer machine via a Deploy project.
I am getting the following error on the customer machine when the app is installed and run.

'Exception: System.ApplicationException: Error - CreateDatagrid Unable to find an entry point named 'OpsConGetAttributes in DLL OraOps10.dll' at .......

I have included Oracle.DataAccess.dll version 10.2.0.100 in the installation and it all appears to be installed in the correct locations.
How can I resolve this problem or what steps can I take to trouble shoot it?
I have carried out test installations on a box with a full 10g client installed in house with no issues so I presume it is likely to be an Oracle Version problem...
c_lawAsked:
Who is Participating?
 
Helena MarkováConnect With a Mentor programmer-analystCommented:
Here are some tips from Oracle MetaLink's Note:312298.1:
....
1. Usually this is an access privilege issue which is documented in Note 215255.1 "Unable to Connect to Database with Oracle Client Software". If that does not resolveNote 215255.1 "Unable to Connect to Database with Oracle Client Software". If that does not resolve the issue reboot the machine after giving all authenticated users IUSR, ASPNET, IWAM, anonymous,  etc to have at a least a READ access to the oracle home on the Web Server machine

OR

2. Missing Oracle software which documented in Note 239722.1 "Deploying VB.NET Application Fails With Unhandled Exception: System.DllNotFoundException: Unable to load DLL OraOps9.dll"

OR

3. Make sure the $ORACLE_HOME\bin is in the PATH statement.

OR

4. Workaround: If for some unclear reasons the issue persists, the following workaround may be employed.

     A. Copy the ORAOPS10.dll from the $ORACLE_HOME\bin folder on Web Server  machine to the IIS 6.0 applications virtual directory \bin folder.

     B. Reboot the machine.

Note: Step 4 workaround requires manual maintenance of the ORAOPS10.dll. If the Oracle client software gets updated on the machine with a new or patched ODP.net the new ORAOPS10.dll needs to be copied over into the apps-virtual-directory\bin.
0
 
c_lawAuthor Commented:
I will get the customer to try these.

"Unable to find an entry point named 'OpsConGetAttributes in DLL OraOps10.dll' at ......." I originally thought this was a versionign problem as it was not saying "Cannot find ORaOps.dll which I have had in the past?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.