Could not load file or assembly 'Oracle.DataAccess, Version=9.2.0.401

Posts   
 
    
like2175
User
Posts: 83
Joined: 27-Mar-2006
# Posted on: 29-Jun-2006 15:54:10   

Using VS 2005 VB.NET

At the first point in my new project when my app attempts some oracle access I get:

System.IO.FileNotFoundException was unhandled by user code
  Message="Could not load file or assembly 'Oracle.DataAccess, Version=9.2.0.401, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified."
  Source="SD.LLBLGen.Pro.DQE.Oracle.NET20"
  StackTrace:
       at SD.LLBLGen.Pro.DQE.Oracle.DynamicQueryEngine.CreateCommand()
       at SD.LLBLGen.Pro.DQE.Oracle.DynamicQueryEngine.CreateSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Boolean relationsSpecified, Boolean sortClausesSpecified)
       at SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase.CreateSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause)
       at SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase.CreateSelectDQ(IEntityFields selectList, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause)
       at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PerformFetchEntityAction(IEntity entityToFetch, ITransaction containingTransaction, IPredicateExpression selectFilter, IPrefetchPath prefetchPathToUse, Context contextToUse)
       at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.FetchExisting(IEntity entityToFetch, ITransaction containingTransaction, IPrefetchPath prefetchPathToUse, Context contextToUse)
       at Fluor.MatCert2.DAL.EntityClasses.AppUserEntityBase.Fetch(String username, 

IPrefetchPath prefetchPathToUse, Context contextToUse) in D:\Data\vss\MatCert2\MatCert2Solution\DAL\EntityBaseClasses\AppUserEntityBase.vb:line 884
       at Fluor.MatCert2.DAL.EntityClasses.AppUserEntityBase.FetchUsingPK(String username, IPrefetchPath prefetchPathToUse, Context contextToUse) in D:\Data\vss\MatCert2\MatCert2Solution\DAL\EntityBaseClasses\AppUserEntityBase.vb:line 371
       at Fluor.MatCert2.DAL.EntityClasses.AppUserEntityBase.FetchUsingPK(String username) in D:\Data\vss\MatCert2\MatCert2Solution\DAL\EntityBaseClasses\AppUserEntityBase.vb:line 354
       at LoginCredentials..ctor(String pstrUsername, String PasswordAttempt) in d:\Data\vss\MatCert2\MatCert2Solution\MatCert2\App_Code\LoginCredentials.vb:line 83
       at Login.cmdOK_Click(Object sender, EventArgs e) in d:\Data\vss\MatCert2\MatCert2Solution\MatCert2\Login.aspx.vb:line 129
       at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
       at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    ''' <returns>True if succeeded, False otherwise.</returns>
        Private Function Fetch(username As System.String, prefetchPathToUse As IPrefetchPath, contextToUse As Context) As Boolean
            Try
                OnFetch()
                Dim dao As IDao = Me.CreateDAOInstance()
                MyBase.Fields(CInt(AppUserFieldIndex.Username)).ForcedCurrentValueWrite(username)
 error on this line----->       dao.FetchExisting(Me, MyBase.Transaction, prefetchPathToUse, contextToUse)
                Dim fetchResult As Boolean = False
                If MyBase.Fields.State = EntityState.Fetched Then
                    MyBase.IsNew = False
                    fetchResult = True
                    If Not contextToUse Is Nothing Then
                        MyBase.ActiveContext = contextToUse
                        Dim dummy As IEntity = contextToUse.Get(Me)

I have seen similar problems with setup projects mentioned. My policy.9.2.Oracle.DataAccess.config file:

<configuration>
   <runtime>
      <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
        <dependentAssembly>
          <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89B483F429C47342"/>
          <bindingRedirect oldVersion="9.2.0.000-9.2.0.999"   newVersion="9.2.0.700"/>
        </dependentAssembly>
      </assemblyBinding>
   </runtime>
</configuration>

My setup:

Name: SelfServicing, two class scenario (Full / Safe) Vs.Net 2005 Version: 1.0.2005.1.10232005

Name: VB.NET template set for Oracle 8i/9i (1.0.2005.1) Version: 1.0.2005.1.102305 Vendor: Solutions Design Target language: VB.NET

SD.LLBLGen.Pro.DQE.Oracle.NET20.dll version: 1.0.20051.060305

Oracle Data Provider for .NET 9.2.0.7.0 installed.

I'm getting nowhere fast, can anyone help?

Help!

Graham

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39590
Joined: 17-Aug-2003
# Posted on: 29-Jun-2006 19:51:58   

Huh? that's really strange...

Could you download the latest runtimes? They're compiled against 9.2.0.7

Frans Bouma | Lead developer LLBLGen Pro
like2175
User
Posts: 83
Joined: 27-Mar-2006
# Posted on: 30-Jun-2006 08:16:18   

simple_smile That fixed it - Thanks! (just in time to save me pulling all of my hair out)