Oracle.DataAccess.DLL connection issues...
453246Oct 5 2005 — edited Nov 4 2005Greetings, all. This Oracle Novice is having some right fun trying to talk to ODP.NET. I am actually very successful at using the 9.2.0.1.0 drivers, so talking to the db is no problem. But I cannot seem to get ODP.NET to work.
I installed all of the available components from the latest ODP.NET download except the one for the Transaction Server. The code I am using is trying to talk to ODP.NET to facilitate a BLOB upload. Here is the line that .NET comes to s screeching halt on:
<%@ Register TagPrefix="oda" Namespace="Oracle.DataAccess" Assembly="Oracle.DataAccess, Version=9.2.0.11, Culture=neutral, PublicKeyToken=89b483f429c47342" %>
And here is the error I receive:
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.11, Culture=neutral, PublicKeyToken=89b483f429c47342
(Fully-specified)
LOG: Appbase = file:///c:/inetpub/wwwroot
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===
LOG: Publisher policy file is found at C:\WINDOWS\assembly\GAC\policy.9.2.Oracle.DataAccess\9.2.0.700__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.11, Culture=neutral, PublicKeyToken=89b483f429c47342
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/root/2135a508/8d69a834/Oracle.DataAccess.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/root/2135a508/8d69a834/Oracle.DataAccess/Oracle.DataAccess.DLL.
LOG: Attempting download of new URL file:///c:/inetpub/wwwroot/bin/Oracle.DataAccess.DLL.
WRN: Comparing the assembly name resulted in the mismatch: Revision Number
I am totally lost as to what all this means. Can someone offer some guidance to this wayward newbie? Thanks!
OH! I should mention that I now have a copy of Oracle.DataAccess.DLL in each of the directories mentioned above.
Steve