I've ported my existing MS SQL Server database schema to DB2. I generated the database specific library and ran it OK for my WinForms app (I was pretty excited at this point). Now, I go to switch the asp.net version of the app and it bombed out. It couldn't load a dll in the SQLLIB directory. I gave the internet user account permissions to that directory and fixed that error. Now the connector wants to access the registry, and I am getting this error:

2006-03-07 14:55:14,734 [3300] ERROR WebMissionFire.Login [] - **APPLICATION ERROR - Requested registry access is not allowed.**
2006-03-07 14:55:14,734 [3300] ERROR WebMissionFire.Login [] -  at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)
   at Microsoft.Win32.RegistryKey.OpenSubKey(String name)
   at IBM.Data.DB2.DB2Resource.a(String A_0, String A_1)
   at IBM.Data.DB2.DB2Resource.a(CultureInfo A_0, String A_1)
   at IBM.Data.DB2.DB2Resource..ctor(CultureInfo cultureInfo, String szResFileName, String szMsgPath)
   at IBM.Data.DB2.DB2Resources.a(CultureInfo A_0)
   at IBM.Data.DB2.z.a(CultureInfo A_0, String A_1, String[] A_2)
   at IBM.Data.DB2.ai.a(x A_0)
   at IBM.Data.DB2.DB2ConnPool.d()
   at IBM.Data.DB2.DB2ConnPool..ctor()
   at IBM.Data.DB2.DB2Connection..cctor()

I've tried finding some fixes for it, all havn't worked for me. I am wondering if anyone else using DB2/ASP.NET has had any of these problems, and if you were able to solve them? IBM's website sucks BTW

I installed the latest fix for the redist pack that they offer. Now I am getting a different error.

2006-03-07 18:06:02,156 [2340] ERROR WebMissionFire.Login [] - **APPLICATION ERROR - Object reference not set to an instance of an object.**
2006-03-07 18:06:02,156 [2340] ERROR WebMissionFire.Login [] -  at SD.LLBLGen.Pro.DQE.DB2.DB2SpecificCreator.CreateObjectName(IFieldPersistenceInfo persistenceInfo)
   at SD.LLBLGen.Pro.DQE.DB2.DB2SpecificCreator.CreateFieldName(IFieldPersistenceInfo persistenceInfo, String fieldName, String objectAlias, Boolean appendAlias, String containingObjectName)
   at SD.LLBLGen.Pro.DQE.DB2.DB2SpecificCreator.CreateFieldName(IEntityFieldCore fieldCore, IFieldPersistenceInfo persistenceInfo, String fieldName, String objectAlias, Int32& uniqueMarker, Boolean applyAggregateFunction)
   at SD.LLBLGen.Pro.DQE.DB2.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.DQE.DB2.DynamicQueryEngine.CreatePagingSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize)
   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, Int32 pageNumber, Int32 pageSize)
   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.CreateSelectDQ(IEntityFields2 fieldsToFetch, IFieldPersistenceInfo[] persistenceInfoObjects, IPredicateExpression filter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize)
   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, Int32 pageNumber, Int32 pageSize)
   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn)
   at MissionFire.BLL.Security.SecurityTicket.Create(String username, String password) in D:\Proyecto MissionFire\Security\SecurityTicket.cs:line 173
   at WebMissionFire.Login.valLogin() in \\192.168.1.200\c$\WebMissionFire\Login.aspx.cs:line 156
   at WebMissionFire.Login.Page_Load(Object sender, EventArgs e) in \\192.168.1.200\c$\WebMissionFire\Login.aspx.cs:line 35
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain()

EDIT Fixed this error now too. One of the columns didn't match the original SQL Server database. Whew.