'Oracle.DataAccess' could not be loaded.

Hi,
I have loaded my web application on my web server. I am using Oracle Database and I have also installed ODP.Net on my server, but every time I try to connect to the database I get this error, 

File or assembly name Oracle.DataAccess, 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 Oracle.DataAccess, 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 'Oracle.DataAccess' could not be loaded.

=== Pre-bind state information ===
LOG: DisplayName = Oracle.DataAccess, Version=9.2.0.700, Culture=neutral, PublicKeyToken=89b483f429c47342
 (Fully-specified)
LOG: Appbase = file:///E:/home/websites/html/veroscapital
LOG: Initial PrivatePath = bin
Calling assembly : VerosCapital, Version=1.0.2161.16716, Culture=neutral, PublicKeyToken=null.
===

LOG: Publisher policy file is found at C:\WINDOWS\assembly\GAC\policy.9.2.Oracle.DataAccess\9.2.0.401__89b483f429c47342\Policy.9.2.Oracle.DataAccess.config.
LOG: No redirect found in host configuration file (C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet.config).
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\config\machine.config.
LOG: Post-policy reference: Oracle.DataAccess, Version=9.2.0.700, Culture=neutral, PublicKeyToken=89b483f429c47342
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/veroscapital/7e22b3e5/15fb0347/Oracle.DataAccess.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/veroscapital/7e22b3e5/15fb0347/Oracle.DataAccess/Oracle.DataAccess.DLL.
LOG: Attempting download of new URL file:///E:/home/websites/html/veroscapital/bin/Oracle.DataAccess.DLL.
LOG: Attempting download of new URL file:///E:/home/websites/html/veroscapital/bin/Oracle.DataAccess/Oracle.DataAccess.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/veroscapital/7e22b3e5/15fb0347/Oracle.DataAccess.EXE.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/veroscapital/7e22b3e5/15fb0347/Oracle.DataAccess/Oracle.DataAccess.EXE.
LOG: Attempting download of new URL file:///E:/home/websites/html/veroscapital/bin/Oracle.DataAccess.EXE.
LOG: Attempting download of new URL file:///E:/home/websites/html/veroscapital/bin/Oracle.DataAccess/Oracle.DataAccess.EXE.

Could anybody please help me.
0
kamini
12/1/2005 5:44:57 PM
asp.net.oracle 2269 articles. 0 followers. Follow

3 Replies
2962 Views

Similar Articles

[PageSpeed] 44

Did you add a reference to Oracle.DataAccess to your project?

--dweezil

SELECT * FROM users WHERE clue = 'yes';

Records found: 0
0
dweezil
12/2/2005 2:27:52 AM

I've had this error happen also. For lack of a better way to put it, seemed like all of a sudden VS2005 just "forgot" about my reference to the ODP.NET assembly I added to my web site. I have gotten around the error by deleting the visual control(s) that were linked to my objectdatasource and then adding them back to the web form and resetting the properties.

The only time I've received the error was with web sites I created that were using an Objectdatasource that referenced some business/data access objects I was prototyping.

BTW, ODP.NET is installed on my development machine where VS2005 is running and I added a reference to the website to the ODP.NET assembly in the GAC.

BK


Bill Kirkman
Concentra Preferred Systems
bkirkman@-nospam-concentra.com
0
wkirkman84
12/2/2005 3:18:11 PM

Something interesting concerning errors I've received that are related to this. It seems like the IDE "forgets" my using statement once an error occurs.

For example, on my web page in the code behind I had the using statement for the Oracle Assembly for ODP.NET. I don't remember exactly what happened to get the error at first but once I got it  I had to delete the code line that the IDE was stating it couldn't find the reference. I then added it back in and the IDE had no problem with the newly added code. This was the exact same line I had just deleted! I then found the compiler now complained about my next in code reference of the assembly. To get it to compile I had to delete/add each reference back into the page then it compiled with no errors.

Strange defect that definitely can cause a lot of extra typing. Anyone else experience this error?


Bill Kirkman
Concentra Preferred Systems
bkirkman@-nospam-concentra.com
0
wkirkman84
12/19/2005 8:57:19 PM
Reply:

Similar Artilces:

Error: Can't load '/cygdrive/c/Oracle/Ora81/bin/Oracle' for module DBD::Oracle...
------_=_NextPart_001_01C4BD25.2E53B509 Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C4BD25.2E53B509" ------_=_NextPart_002_01C4BD25.2E53B509 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi guys, =20 Here is what's going on:=20 =20 1. I am running the latest release of CygWin on a Windows XP machine. I am not running ActiveState Perl. 2. I installed DBI and tested it. Looks like it's working fine. I typed: =20 perl -MDBI -e 0 =20 at the ...

Getting Error Message "Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle
--755704646-1080936359-1390695547=:84331 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I am trying to configure an Oracle connection from Perl running on a Window= s 7 desktop to an Oracle 11g database running on Linux; however the databas= e connection step is failing.=0A=0AThe following line of perl code fails:= =0A=0A=A0 =A0use DBD::Oracle;=0A=0ABelow is the full error message:=0A=0ACa= n't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:= load_file:%1 is not a valid Win32 application at C:/Perl64/lib/D...

''''''''''''''''''''
Name: haznen Email: haznenatyahoodotcom Product: Gran Paradiso Alpha 8 Summary: '''''''''''''''''''' Comments: '''''''''''''''''''''''''''''''''''' Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a1) Gecko/20061204 UGES/1.7.2.0 GranParadiso/3.0a1 From URL: http://www.mozilla.org/projects/granparadiso/ Note to readers: Hendrix gives...

'''''
Name: mario Email: ramar17atfastwebnetdotit Product: Gran Paradiso Alpha 2 Summary: ''''' Comments: K: Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a2) Gecko/20070206 GranParadiso/3.0a2 ...

Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.100, Culture=neutral, PublicKeyToken=89b483f429c47342'
Hi, I am using ASP.net 2.0 and ODP.net for my application. I created my application in VS 2005. I developed my app on a PC having Oracle 10g client. I build the deployable using the VS 2005 web installation project. I deployed the application on my development server and it works fine. When I moved the app to my UAT server it stopped working. The error message is at the end of this post. I have ODP.Net, ASP.net 2.0 on the server. The server is Windows 2003 with IIS 6.0. The GAC has Oracle assembly. The UAT server has both Oracle 10g as well as Oracle 9i client in different ...

help! why i can not use ' out parameter' in 'oracle procedure'
i compile and execute the procedure in sqlplus(oracle tools) but i can not use it in powerbuilder. foe example: the procedure is : CREATE or replace PROCEDURE spm1 (dept varchar2 ,mgr_name out varchar2) IS lutype varchar2(10); BEGIN mgr_name:=dept||'out end'; END; the powerbuilder scipt is : DECLARE gg PROCEDURE FOR SPM1 (:dept1); execute gg; messagebox("",string(sqlca.sqlcode)+sqlca.sqlerrtext) i get error,and the error is : pls:00306. and oracle document explain the error is : PLS-00306: wrong number or t...

2008-09-24 16:32:38
Dear all     i spend my whole working day just to look at this and i still get the error messsage above here how it goes     The Problem     i have created a simple application that queries an oracle live database.... and my objective is to move it over to then development server....    when i tried to run from the development server it doesn't seem to work at all and i get following error message 2008-09-24 16:32:38 - (SQL_Ecard:GetECardTemplate) Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.100, ...

'do' won't 'do' if '/'
Greetings to All from Au, Have a NetWare Perl 5.8.4 and wanted to tweak File\Spec\NW.pm to try and standardise on '/' separators. If I run a test script (t/uni/lower.t) with an unmodified NW.pm, it calls t/uni/case.pl, that, in case.pl, (when the path separators are '\'), the $file is '..\lib\unicore\To\Lower.pl' and the following code portion works, with $simple getting a returned table: sub casetest { my ($base, $spec, $func) = @_; my $file = File::Spec->catfile(File::Spec->catdir(File::Spec->updir, "lib", &qu...

Database 'for load' or 'is suspect'
Hello, I am trying to delete a database 'test'. But when I try to open it using 'isql' or 'sybase central', I am getting this message - "Database 'test' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information a to the cause". I saw the error logs, but was not able to fine anything useful to me. Is there a way I can override this error and delete the database? Thank you. This is a multi-part message in MIME format. --------------5A483A9731238CB1DF190265 Content-Type: te...

Cannot load type '' in assembly ''
Can't over emphasize how MUCH time I have wasted on this one.... I've got an app that has refs to components A, B, and C.  A references B and C, and B references C.  I updated C but VS keeps replacing it with the previous version!  I've deleted all temporary files, backup files, websie cache, component C from the bin directory, and rebooted.  Somehow VS keeps resurrecting the previous version of the dll (where it's getting it I absolutely do NOT know!)  I seriously want to chuck VS out the window when I go round and round with crap like this! &nbs...

Database 'For load' or 'is suspect'
Hello, I am trying to delete a database 'test'. But when I try to open it using 'isql' or 'sybase central', I am getting this message - "Database 'test' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information a to the cause". I saw the error logs, but was not able to fine anything useful to me. Is there a way I can override this error and delete the database? Thank you. Andy wrote: > I am trying to delete a database 'test'. But when I try to open it using ...

BC30002: Type 'Oracle.DataAccess.Client.OracleConnection' is not defined.
Could someone assist me in tracing the error : BC30002: Type 'Oracle.DataAccess.Client.OracleConnection' is not defined. I add the reference also but still getting the same error. Am using Windows 2003, IIS 6.0 My code is : <%@ Page Language="VB" %> <%@ Import Namespace="System.Data"%> <%@ import Namespace="Oracle.DataAccess.Client" %> <%@ import Namespace="Oracle.DataAccess.types" %> <script runat="server"> Private Sub Page_Load(sender As Object, e As EventArgs) ' Insert page code here Dim con As Oracle.DataAccess.Client.OracleConnection = Nothing con = New Oracle.DataAccess.Client.OracleConnection con.ConnectionString = "User Id=scott;Password=tiger;Data Source=mysite" con.Open() response.write ("Success") End sub </script> <html> <head> </head> <body> <form runat="server"> <!-- Insert content here --> </form> </body> </html> i guess there is some problem with the reference. i presume the oracle.dataacess dll should be in gac. anyways try the following: 1. select the oralce.dataacess dll and right click 2. and make the copylocal property to true. in shor...

'''
Name: L Lachowsky Email: e2brutus_10atyahoodotcom Product: Firefox Summary: ''' Comments: why duddn this surprise me... I change default server from IE to Mozilla, and then i get error messages. well, shud I decide to not get on my computer with Mozilla..or shud I risk security breeches with IE....hmmm at least i can get on the internet with IE Browser Details: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this fee...

BC30002: Type 'Oracle.DataAccess.Client.OracleConnection' is not defined
Could someone please help me in tracing the error, "BC30002: Type 'Oracle.DataAccess.Client.OracleConnection' is not defined". I added the reference too,but still getting the same error Am using windows 2003, IIS 6.0 My Code: <%@ Page Language="VB" %> <%@ Import Namespace="System.Data"%> <%@ import Namespace="Oracle.DataAccess.Client" %> <%@ import Namespace="Oracle.DataAccess.types" %> <script runat="server"> Private Sub Page_Load(sender As Object, e As EventArgs) ...

'Oracle.DataAccess.Client.OracleCommand.Transaction' cannot be assigned to -- it is read only
Hi,  We are converting our existing data access code for Oracle Database. And For methods which are envolved with Transaction I am getting following error.  command.Transaction = this._sqlTransaction;  Error:  Property or indexer 'Oracle.DataAccess.Client.OracleCommand.Transaction' cannot be assigned to -- it is read only Urgently Help Required. Thanks.  Vishal Could you please post more code showing details of   this._sqlTransaction  ? What is it and how is it created?Regards,PrashantDont forget to click "Mark as Answer" on the ...

Cast from type ''''DBNull'''' to type ''''String'''' is not valid.
How do I avoid getting this error: Cast from type ''''DBNull'''' to type ''''String'''' is not valid. I am trying to get values from the database into a form for updating using a Datareader, SQL is set to allow nulls for certain fields as they are not required but the only way I can get the form to display is by adding a space in SQL. Is there another way around this? Check if it is equal to DBNull.Value first and if it is, don't do the cast.Stanley Tan theSpoke Blog Where in the code does it need to go? I am using the following and it's the profile that isn't always requi...

The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception
I have a VB .Net 2.0 web application which accesses oracle 8i database, the database was upgraded to 9i later on. The application worked fine just before the upgrade was made, but after the upgrade the application gives the following error. The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. I did a few searches in the oracle forums and downloaded and installed the Oracle Data Provider for .NET  version 9.2.0.4 form orcale website but the application still throws out the above exception. following is the stack trace of the application from the point of failure'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.A first chance exception of type 'System.TypeInitializationException' occurred in WebApplication2.DLLSystem.Transactions Critical: 0 : <TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Critical"><TraceIdentifier>http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier><Description>Unhandled exception</Description><AppDomain>235fed96-1-128578546213452400</AppDomain><Exception><ExceptionType>System.TypeInitializationException, mscorlib, Version=2.0.0.0, Culture=neutral, Publ...

Getting 'Unrecognized attribute 'xmlns'.' when attempting to load NET 1.1 app in IIS
 Hi all,I am getting this message that is pointing to the web.config at INETPUB\WWWROOT\. I have both .NET 1.1 and .NET 2.0 installed and was able to run .NET 1.1 apps fine through my local IIS up until 3 weeks ago. I am not sure what has changed, so cant really pinpoint where the problem may have originated.I have run aspnet_regiss -r to updated the scriptmaps for .1.1 but I still get the problem?I also have the ASP.NET tab of the applications virtual directory pointing at NET 1.1. and all the ASP.NET tab of the 'default website' set to .NET 1.1.Also, my .NET 2.0 apps work fine...

test DBD::Oracle DBI connect('','user/password@database',...) failed: ORA-12154
--0-621501335-1235620987=:55352 Content-Type: text/plain; charset=us-ascii I can connect to the database using sqlplus as user oracle, but not as root. I can compile DBD::Oracle but not complete the test. I tried to set variables properly: ORACLE_HOME=/u/oracle/10.2.0 ORACLE_HOST=hostname ORACLE_PORT=1522 ORACLE_SID=databasename ORACLE_USERID=user/password@databasename PATH=/u/oracle/10.2.0/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin PWD=/usr/src/pub/dbd-oracle/DBD-Oracle-1.22 TNS_ADMIN=/u/or...

table_info('','','','%') cannot return any types
I was recently confirming table_info special cases and discovered the case for getting table_types cannot work. table_info('','','','%') should return a list of table types but it returns a list of empty strings instead: my @types = $h->tables('', '', '', '%'); print "all types:\n", join("xxx\n", @types), "\n"; # should output something like: # "dbo" # "INFORMATION_SCHEMA" # "sys" # and actually outputs: xxx xxx It seems to be down to the following ...

'Out of memory' / 'Parameter is not valid' at 'System.Drawing.Image' load
 Hi,   i have a problem with loading images. what is interesting the same type of images, the same directories some of them are loading some - not. The image size doesn't matter. It happens on a big sized and on a small sized image. So..   int id = Int32.Parse(Request.Params["id"].ToString());string sImage = "";Response.Clear();Response.ContentType = "image/JPEG";Response.Expires = 0;Response.Buffer = true;Response.Clear();sImage = GetMarkImagePath(id);FileStream fs = new FileStream(sImage, FileMode.Open, FileAccess.Read);// the foll...

Problems installing DBD::Oracle
> Hi guys, > > I've read the README, I've spent the last 2 hours scanning the net, and > although I've seen that other people are having this problem, I haven't > found a solution anywhere! (The two suggestions I found didn't work :-(. > > The DBD::Oracle tests fail with the message: > > install_driver(Oracle) failed: Can't load > 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: > shared object not open at > /usr/local/packages/perl-5.6.1/lib/5.6.1/i686-linux/DynaLoader.pm line > 206. > ...

Re: DBD:Oracle-1.19 Can't load Oracle.dll
------_=_NextPart_001_01C7801F.6E16B57A Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi,=20 =20 I=20have=20a=20slight=20problem=20with=20the=20installation=20of=20DBD::Or= acle=201.19=20using the=20cygwin=20environment=20running=20on=20Win2003=20R2=20Standard=20edit= ion=20sp1 machine. The=20version=20of=20Oracle=20I=20am=20using=20is=2010.2.0=20. Here=20is=20the=20output=20from=20make=20test=20command=20: ------------------------------------------------------------------------ ------------------------------------...

very specific DBD::Oracle issue, but I'm not exactly sure if it's the file Oracle.so or libclntsh.so.10.1
DQoNCg0KDQp0aGUgZXJyb3INCmluc3RhbGxfZHJpdmVyKE9yYWNsZSkgZmFpbGVkOiBDYW4ndCBs b2FkDQonL3Vzci9sb2NhbC9saWIvcGVybDUvc2l0ZV9wZXJsLzUuOC44Lw0KaTY4Ni1saW51eC9h dXRvL0RCRC9PcmFjbGUvT3JhY2xlLnNvJyBmb3IgbW9kdWxlIERCRDo6T3JhY2xlOg0KbGliY2xu dHNoLnNvLjEwLjE6DQogY2Fubm90IG9wZW4gc2hhcmVkIG9iamVjdCBmaWxlOiBObyBzdWNoIGZp bGUgb3IgZGlyZWN0b3J5IGF0DQovdXNyL2xvY2FsL2xpYi9wZXINCmw1LzUuOC44L2k2ODYtbGlu dXgvRHluYUxvYWRlci5wbSBsaW5lIDIzMC4NCiBhdCAoZXZhbCA4KSBsaW5lIDMNCkNvbXBpbGF0 aW9uIGZhaWxlZCBpbiByZXF1aXJlIGF0IChldmFsIDgpIGxpbmUgMy4NClBlcmhhcHMgYSByZXF1 aXJlZCBzaGFyZWQgbGlicmFyeSBvciBkbGwgaXNuJ3QgaW5zdGFsbG...

Web resources about - 'Oracle.DataAccess' could not be loaded. - asp.net.oracle

Resources last updated: 3/11/2016 1:14:59 PM