Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle access problems in MM.NET
Message
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
Oracle access problems in MM.NET
Miscellaneous
Thread ID:
01011416
Message ID:
01011416
Views:
172
When I try to use Oracle 9i in MM.NET, right off the bat the user login fails with the error below. The invalid table name (I assume it's referring to MM.NET's 'users' table does exist and can be accessed using another non-MM.NET application using the same data provider. Any clues?
One or more errors occurred during processing of command. ORA-00903: invalid table name 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.OleDb.OleDbException: One or more errors occurred during processing of command. ORA-00903: invalid table name

Source Error: 


Line 97:         Session("myLoginStatus") = "On"
Line 98: 
Line 99:         If (Not Me.Login()) Then
Line 100:            Me.lblErrorMessage.Text = Me.ErrorMessage
Line 101:            Session("cerLoginStatus") = "Off"
 

Source File: C:\Inetpub\wwwroot\SITF\UserLogin.aspx.vb    Line: 99 

Stack Trace: 


[OleDbException (0x80040e14): One or more errors occurred during processing of command.
ORA-00903: invalid table name]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
   System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   OakLeaf.MM.Main.Data.mmDataAccessBase.ExecReader(String command, IDbConnection& connection, IDbDataParameter[] dataParams)
   OakLeaf.MM.Main.Business.mmBusinessObject.ExecReader(String command, String databaseKey, IDbConnection& connection, IDbDataParameter[] dataParams)
   OakLeaf.MM.Main.Managers.mmUserManager.AuthenticateUser(String userID, String password, String databaseKey)
   OakLeaf.MM.Main.Web.UI.mmBaseUserLogin.Login()
   SITF.ClaimsAdministration.Web.UserLogin.btnLogin_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\SITF\UserLogin.aspx.vb:99
   System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   System.Web.UI.Page.ProcessRequestMain()

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 
Carl Olson, Jr.
CEO, Founder
Cerelogic, Inc.

www.cerelogic.com

"Applying rocket science to business."
Next
Reply
Map
View

Click here to load this message in the networking platform