Wrox Programmer Forums
|
ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 4th, 2006, 05:41 AM
Authorized User
 
Join Date: Mar 2006
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Invalid Object Name

I have a web application which throws an error while I am trying to insert a row in a table. Following is the error, could anyone help.


Server Error in '/hollywood' Application.
----------------------------------------------------------------
Invalid object name 'dbo.t_Passport'.
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.SqlClient.SqlException: Invalid object name 'dbo.t_Passport'.

Source Error:


Line 351: ObjConnection.open()
Line 352:
Line 353: objCmd.ExecuteNonQuery()
Line 354: ObjConnection.Close()
Line 355:


Source File: C:\dotnet\ADDADMIN\newemp.aspx Line: 353

Stack Trace:


[SqlException: Invalid object name 'dbo.t_Passport'.]
   System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +193
   ASP.newemp_aspx.AddNewEmp1(Object s, EventArgs e) in C:\dotnet\ADDADMIN\newemp.aspx:353
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1292




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032

 
Old July 5th, 2006, 11:13 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
Default

Either that table does not exist or it is not a dbo table, IE the table was created with some other user name.






Similar Threads
Thread Thread Starter Forum Replies Last Post
invalid object dbo.split error............ hepsy.i ASP.NET 1.0 and 1.1 Professional 1 August 8th, 2007 06:31 PM
invalid object name 'Groups' marco_27 VB Databases Basics 3 April 16th, 2007 01:59 PM
Invalid Object Name "Groups" Charlie05 VB Databases Basics 4 April 14th, 2007 10:54 AM
"Invalid object format name" Error welles Crystal Reports 2 September 27th, 2006 04:42 AM
Invalid object name Syed Naveed Khursheed BOOK: Beginning ASP 3.0 8 November 20th, 2004 01:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.