Skip to Main Content
Forums

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Could not load file or assembly 'Oracle.DataAccess error on server

860285Jun 2 2011 — edited Jun 6 2011
I have been building a.NET application on my local Machine Windows 7 and have the 32-bit ODT installed on my machine which works nicely with VS 2010.

I placed it on the server and when I open the page that accesses data from Oracle, I get the below error. Both the server and my local computer have the Oracle.DataAccess
dll installed and both have the same public token 89b483f429c47342. I changed the target CPU from Any CPU to x86 and published a Release build of my project to the server.

Why am I getting the below error?

==========================================================================================================
Could not load file or assembly 'Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Assembly Load Trace: The following information can be helpful to determine why the assembly 'Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' could not be loaded.


WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Stack Trace:


[FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.]
antac.dashboard.Page_Load(Object sender, EventArgs e) in C:\Users\George\Documents\Visual Studio 2010\Projects\antac\antac\dashboard.aspx.cs:92
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
System.Web.UI.Control.LoadRecursive() +71
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3048




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
This post has been answered by Christian.Shay -Oracle on Jun 3 2011
Jump to Answer

Comments

gerardnico
Just create two answers and give them the authorization to only one group.

You will end up with:
- one answers at transaction level for the standard group
- one answers at total level for the standard group

Cheers
Nico
1 person found this helpful
user11440683
This is currently my workaround solution, but I dislike it for maintenance / enhancement reasons....


thanks for your input though,


Robert.
gerardnico
You have an other solution which is the audit.
Just add a hide column to get the user and add it in your SQL statement.

I prefer audit than to implement security.
You have more flexibility.

Cheers
Nico
user11440683
Hi Nico,


what do you mean by 'audit'?


From what you expand, am I presuming that you mean I; -


1. Add a column that gets user name or user group to ascertain if user should be allowed writeback
2. Hide column

And then still allow postback (yes?) but itercede some logic that picks up the hidden user / group value and IF group user = allowed THEN continue as normal ELSE do nothing??

Is this what you mean, if not then kindly explain audit??


regards,

Robert.
gerardnico
Answer
I mean:
- add a column in answer with the name of the user
- add a user column in the target table
- use it in your writeback SQL statement to update it

You can then know who is the last user who has updated the data.
You can also add a trigger on the write back table to seed an history table.

no IF THEN ELSE/security logic, just an audit to know which user has updated the data in case of
conflict or just to give a better formation.

Cheers
Nico

Edited by: gerardnico on Aug 23, 2010 10:51 AM has and not have
Marked as Answer by user11440683 · Sep 27 2020
user11440683
Ok.

Thanks for your input and clarification.

In this case the users should not be allowed this level of input so prohibiting the behaviour entirely is my only option, but I understand where you are coming from...


thanks again,

Robert.
gerardnico
If you want, you can implement the security in the trigger ;-)
But it's more work and not very maintainable.

Success
Nico
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 4 2011
Added on Jun 2 2011
#oracle-developer-tools-for-visual-studio
2 comments
3,955 views