Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Bugs & Issues> Could not load file or assembly 'Oracle.DataAccess, Version=9.2.0.401
 

Pages: 1
Bugs & Issues
Could not load file or assembly 'Oracle.DataAccess, Version=9.2.0.401
Page:1/1 

  Print all messages in this thread  
Poster Message
like2175
User



Location:
Camberley, United Kingdom
Joined on:
27-Mar-2006 16:16:06
Posted:
83 posts
# 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:

Code:
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)


Code:

    ''' <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:
Code:
<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
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37804 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
like2175
User



Location:
Camberley, United Kingdom
Joined on:
27-Mar-2006 16:16:06
Posted:
83 posts
# Posted on: 30-Jun-2006 08:16:18.  
Regular Smiley That fixed it - Thanks! (just in time to save me pulling all of my hair out)
  Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.