File or assembly name Oracle.DataAccess not found.

G

Guest

I am trying to deploy an ASP.NET solution using ODP.NET to a server and
receive the error:

File or assembly name Oracle.DataAccess, or one of its dependencies, was not
found.

I see the Oracle.DataAccess.dll in the Oracle_Home\bin directory and Other
OLE access to Oracle is working just fine using the same Oracle_Home.

How does my ASP.NET application determine where to locate the required
Oracle.DataAccess files? What else do I need to do be able to make my ASP.NET
applications work using the Oracle .NET provider?

Much Thanks - Stan
 
N

Nik

Hello

I am trying to use the System.Data.Oraclient for my ASP.NET application
.. But I am getting the following error message.



File or assembly name System.Data.OracleClient, or one of its
dependencies, was not found.
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: File or assembly
name System.Data.OracleClient, or one of its dependencies, was not
found.

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 'System.Data.OracleClient' could not be
loaded.


=== Pre-bind state information ===
LOG: DisplayName = System.Data.OracleClient, Version=1.0.3300.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089
(Fully-specified)
LOG: Appbase = file:///C:/Inetpub/Nik_Development
LOG: Initial PrivatePath = bin
Calling assembly : auditdev2.kdc.capitalone.com,
Version=1.0.2106.24581, Culture=neutral, PublicKeyToken=null.
===

LOG: Publisher policy file is not found.
LOG: No redirect found in host configuration file
(C:\WINNT\Microsoft.NET\Framework\v1.1.4322\aspnet.config).
LOG: Using machine configuration file from
C:\WINNT\Microsoft.NET\Framework\v1.1.4322\config\machine.config.
LOG: Post-policy reference: System.Data.OracleClient,
Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/ae0b0602/52e78a83/System.Data.OracleClient.DLL.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/ae0b0602/52e78a83/System.Data.OracleClient/System.Data.OracleClient.DLL.
LOG: Attempting download of new URL
file:///C:/Inetpub/Nik_Development/bin/System.Data.OracleClient.DLL.
LOG: Attempting download of new URL
file:///C:/Inetpub/Nik_Development/bin/System.Data.OracleClient/System.Data..OracleClient.DLL.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/ae0b0602/52e78a83/System.Data.OracleClient.EXE.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/ae0b0602/52e78a83/System.Data.OracleClient/System.Data.OracleClient.EXE.
LOG: Attempting download of new URL
file:///C:/Inetpub/Nik_Development/bin/System.Data.OracleClient.EXE.
LOG: Attempting download of new URL
file:///C:/Inetpub/Nik_Development/bin/System.Data.OracleClient/System.Data..OracleClient.EXE.



Stack Trace:


[FileNotFoundException: File or assembly name System.Data.OracleClient,
or one of its dependencies, was not found.]
auditdev2.kdc.capitalone.com.WebForm1.Button1_Click(Object sender,
EventArgs e) +0
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+33
System.Web.UI.Page.ProcessRequestMain() +1292






I have changed the permissions on Ora817 folder under program files and
that has not helped. Any clue why this must be happenning..

THanks a bunch
 
G

Guest

Nik -

Did you set security for the Oracle dll's as Paul has outlined? That has
cured my problems in the past with the Oracle issues...

Stan

Nik said:
Hello

I am trying to use the System.Data.Oraclient for my ASP.NET application
.. But I am getting the following error message.



File or assembly name System.Data.OracleClient, or one of its
dependencies, was not found.
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: File or assembly
name System.Data.OracleClient, or one of its dependencies, was not
found.

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 'System.Data.OracleClient' could not be
loaded.


=== Pre-bind state information ===
LOG: DisplayName = System.Data.OracleClient, Version=1.0.3300.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089
(Fully-specified)
LOG: Appbase = file:///C:/Inetpub/Nik_Development
LOG: Initial PrivatePath = bin
Calling assembly : auditdev2.kdc.capitalone.com,
Version=1.0.2106.24581, Culture=neutral, PublicKeyToken=null.
===

LOG: Publisher policy file is not found.
LOG: No redirect found in host configuration file
(C:\WINNT\Microsoft.NET\Framework\v1.1.4322\aspnet.config).
LOG: Using machine configuration file from
C:\WINNT\Microsoft.NET\Framework\v1.1.4322\config\machine.config.
LOG: Post-policy reference: System.Data.OracleClient,
Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/ae0b0602/52e78a83/System.Data.OracleClient.DLL.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/ae0b0602/52e78a83/System.Data.OracleClient/System.Data.OracleClient.DLL.
LOG: Attempting download of new URL
file:///C:/Inetpub/Nik_Development/bin/System.Data.OracleClient.DLL.
LOG: Attempting download of new URL
file:///C:/Inetpub/Nik_Development/bin/System.Data.OracleClient/System.Data..OracleClient.DLL.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/ae0b0602/52e78a83/System.Data.OracleClient.EXE.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/root/ae0b0602/52e78a83/System.Data.OracleClient/System.Data.OracleClient.EXE.
LOG: Attempting download of new URL
file:///C:/Inetpub/Nik_Development/bin/System.Data.OracleClient.EXE.
LOG: Attempting download of new URL
file:///C:/Inetpub/Nik_Development/bin/System.Data.OracleClient/System.Data..OracleClient.EXE.



Stack Trace:


[FileNotFoundException: File or assembly name System.Data.OracleClient,
or one of its dependencies, was not found.]
auditdev2.kdc.capitalone.com.WebForm1.Button1_Click(Object sender,
EventArgs e) +0
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+33
System.Web.UI.Page.ProcessRequestMain() +1292






I have changed the permissions on Ora817 folder under program files and
that has not helped. Any clue why this must be happenning..

THanks a bunch













Paul said:
¤ Thanks Paul.
¤
¤ Yesterday, I installed the ODP.NET and used these setup steps from your
¤ previous posts and got the app working. I believe my issue is the Instant
¤ Client not supporting the .NET.
¤

Yes, the instant client does not provide nearly enough functionality.

¤ Is there any easy way to tell what Oracle client is installed on the server?
¤

You can probably look at the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE Registry key. Just keep in mind that
it is possible to have more than one Oracle client installed at the same time.


Paul
~~~~
Microsoft MVP (Visual Basic)
Click to expand...
Click to expand...
 
P

Paul Clement

¤ Hello
¤
¤ I am trying to use the System.Data.Oraclient for my ASP.NET application
¤ . But I am getting the following error message.
¤
¤
¤
¤ File or assembly name System.Data.OracleClient, or one of its
¤ dependencies, was not found.
¤ 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: File or assembly
¤ name System.Data.OracleClient, or one of its dependencies, was not
¤ found.
¤

Yeah, I would check the information from my first reply to verify that everything is configured
properly with respect to permissions.


Paul
~~~~
Microsoft MVP (Visual Basic)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error connecting to Oracle 6
Building C# from command line and referencing Oracle ODP.Net 2
Problem using Oracle in my code. 3
OCI.DLL: The specified module could not be found + OCIEnvCreate fa 2
ORA:12154 TNS Could Not Resolve Service Name 2
Unable to add reference 0
File or assembly name ADODB, was not found. 1
Problems connecting to Oracle 9i database with Oracle 10g Client and Win XP x64 2

Top