ORA-00942: table or view does not exist
[OracleException (0x80004005): ORA-00942: table or view does not exist]
Devart.Data.Oracle.cc.d() +1518
Devart.Data.Oracle.bu.m() +95
Devart.Data.Oracle.bu.a() +2942
Devart.Data.Oracle.l.a(Int32 A_0, ci A_1) +4465
Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery) +4113
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) +1182
Devart.Common.DbCommandBase.ExecuteScalar() +28
Devart.Common.Web.Providers.DbExtendedMembershipProvider.a(DbDatabaseManager A_0, String A_1) +325
Devart.Common.Web.Providers.DbExtendedMembershipProvider.b(DbDatabaseManager A_0, String A_1, Boolean A_2) +31
Devart.Common.Web.Providers.DbExtendedMembershipProvider.ValidateUser(String username, String password) +164
[ProviderException: Error validating user]
Devart.Common.Web.Providers.DbExtendedMembershipProvider.ValidateUser(String username, String password) +549
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +105
System.Web.UI.WebControls.Login.AttemptLogin() +160
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +93
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +84
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804
I have the devart version 8.4.293.4
I have run the scripts provided by devart to create oracle tables but would like to use existing ones if possible.
web.config
Code: Select all
<roleManager enabled="true" defaultProvider="OracleExtendedRoleProvider" cacheRolesInCookie="true" cookieName=".localV4AdminWibbleEURoles" cookieTimeout="7200" cookiePath="/"
cookieRequireSSL="false" cookieSlidingExpiration="true" cookieProtection="All" createPersistentCookie="false" maxCachedResults="25">
<providers>
<clear />
<remove name="OracleExtendedRoleProvider"/>
<add connectionStringName="OracleAdminConnection" name="OracleExtendedRoleProvider" type="Devart.Data.Oracle.Web.Providers.OracleExtendedRoleProvider, Devart.Data.Oracle.Web, Version=8.4.293.4, Culture=neutral, PublicKeyToken=09af7300eec23701" useridcolumn="UserId" usernamecolumn="UserName" usertablename="ORA_ASPNET_USERS" />
<!--<add applicationName="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" />-->
</providers>
</roleManager>
<profile enabled="true" defaultProvider="TableProfileProvider" inherits="Wibble.Common.Admin.ProfileCommon, Wibble.Common.Admin">
<providers>
<clear />
<add name="TableProfileProvider" type="Wibble.Common.Admin.SqlTableProfileProvider, Wibble.Common.Admin" connectionStringName="OracleAdminConnection" table="PCS_CRM_AdminProfile" applicationName="WibbleEuropeAdministration" />
</providers>
</profile>
<membership defaultProvider="OracleExtendedMembershipProvider">
<providers>
<clear />
<remove name="OracleExtendedMembershipProvider"/>
<add name="OracleExtendedMembershipProvider" type="Devart.Data.Oracle.Web.Providers.OracleExtendedMembershipProvider, Devart.Data.Oracle.Web, Version=8.4.293.4, Culture=neutral, PublicKeyToken=09af7300eec23701"
connectionStringName="OracleAdminConnection" applicationName="WibbleEuropeAdministration"
enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="true"
passwordFormat="Hashed" maxInvalidPasswordAttempts="4" minRequiredPasswordLength="9" passwordAttemptWindow="8" useridcolumn="UserId" usernamecolumn="UserName" usertablename="ORA_ASPNET_USERS" />
</providers>
</membership>