Home ›
ASP.NET Forums » Starter Kits and Source Projects » Club Web Site Starter Kit » DB error: Invalid object name 'dbo.Events'

DB error: Invalid object name 'dbo.Events'

Last post 10-03-2009 11:19 AM by RajibRoy. 13 replies.

Sort Posts:

  • DB error: Invalid object name 'dbo.Events'

    05-09-2005, 5:07 PM
    • Member
      40 point Member
    • ferdz
    • Member since 05-09-2005, 5:43 PM
    • Posts 8

    Hi,
    I am getting the error posted down below. I used the script ClubAdd.exe from MSDN to add the club tables to my SQL2000 database. I noticed in the error it is looking for dbo.Events and dbo.Locations. These tables exists in my database. However, the tables the owner is not dbo but instead my database login name. Is that the reason for the error? I don't think that that matters, but any way I would appreciate your input to this.

    Thanks

     

    Server Error in '/' Application.

    Invalid object name 'dbo.Events'.
    Invalid object name 'dbo.Locations'.

    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.Events'.
    Invalid object name 'dbo.Locations'.

    Source Error:

    An unhandled exception was generated during the execution of the
    current web request. Information regarding the origin and location
    of the exception can     be identified using the exception stack trace below.


    Stack Trace: 

    [SqlException (0x80131904): Invalid object name 'dbo.Events'.
Invalid object name 'dbo.Locations'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +785922
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +684534
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +207
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, 

            BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1751
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +37
   System.Data.SqlClient.SqlDataReader.get_MetaData() +58
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +213
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
                  Boolean async) +570
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
                      String method, DbAsyncResult result) +134
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
                   String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, 
             IDbCommand command, CommandBehavior behavior) +141
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, 
             CommandBehavior behavior) +137
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1837
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +129
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
   System.Web.UI.WebControls.GridView.DataBind() +4
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
   System.Web.UI.Control.EnsureChildControls() +87
   System.Web.UI.Control.PreRenderRecursiveInternal() +41
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787

  • Re: DB error: Invalid object name 'dbo.Events'

    05-10-2005, 6:00 PM
    • Member
      40 point Member
    • ferdz
    • Member since 05-09-2005, 5:43 PM
    • Posts 8
    bump. Anyone? Help!

  • Re: DB error: Invalid object name 'dbo.Events'

    05-13-2005, 10:48 AM
    • Member
      40 point Member
    • ferdz
    • Member since 05-09-2005, 5:43 PM
    • Posts 8

    SOLVED!

    I thought I would get answer from this forum. Obviously not. Perhaps my question was so stupid that no one bothers. Anyway, I'm happy that in the end I am contributing instead. So for those of you who wil encounter this error here is the solution.

    Well, the solution would be to edit all queries with "dbo." in field names. This is easily done by search and replace. (I really feel stupid now Embarrassed [:$] )

  • Re: DB error: Invalid object name 'dbo.Events'

    06-13-2005, 1:44 AM
    • Member
      292 point Member
    • jdub12
    • Member since 08-01-2002, 7:28 PM
    • Posts 67
    edit all the queries in the db to have dbo. in the front or the pages aspx pages themselves?

  • Embarrassed [:$] Re: DB error: Invalid object name 'dbo.Events'

    06-24-2005, 5:35 PM
    • Member
      25 point Member
    • Fleck
    • Member since 06-03-2005, 9:57 PM
    • Posts 5
    I'm not able to figure out your solution, could you post a step by step?
    And if you felt stupid, I'm sure you can imagine how I feel!
    Thank you

  • Re: DB error: Invalid object name 'dbo.Events'

    07-06-2005, 3:32 PM
    • Member
      40 point Member
    • ferdz
    • Member since 05-09-2005, 5:43 PM
    • Posts 8
    Hey Jdub,
    I edited the .aspx files.

  • Re: DB error: Invalid object name 'dbo.Events'

    07-06-2005, 3:34 PM
    • Member
      40 point Member
    • ferdz
    • Member since 05-09-2005, 5:43 PM
    • Posts 8
    Hey Fleck,

    I don't have VS2005 in front of me so the following may not be the exact.
    1. Select "Edit" menu and do a Search and Replace of all files in the project
    2. Find: dbo.
    3. Replace: (empty)
    4. Click Replace button

  • Re: DB error: Invalid object name 'dbo.Events'

    07-10-2005, 8:54 AM
    • Member
      25 point Member
    • Fleck
    • Member since 06-03-2005, 9:57 PM
    • Posts 5
    That did it.  Much appreciated

    Thank you,

    Fleck

  • Re: DB error: Invalid object name 'dbo.Events'

    12-20-2005, 12:38 PM
    • Member
      25 point Member
    • beta_2
    • Member since 08-27-2003, 11:41 AM
    • Ocean City, MD
    • Posts 5
    Works great!  Thanks for posting your solution.  Thats what these forums are for.  Take care.

  • Re: DB error: Invalid object name 'dbo.Events'

    12-30-2005, 1:05 PM
    • Member
      25 point Member
    • btech_rohit
    • Member since 11-29-2005, 9:34 PM
    • India
    • Posts 5
    These are the files where "dbo." is to be replaced with ""

    1)Default.aspx
    2)Events_edit.aspx
    3)Events_view.aspx

    No other files need to be touched for the change.
    and "dbo." is case sensitive. Its not the same as "Dbo."

    and these change is to be applied at only those places, where you find
    "dbo.Events" or "dbo.Locations"

    If some one needs the changed files i can help.
     i am having the success full implementation of club starter kit on www.rohitjain.com







    ferdz wrote:

    Hi,
    I am getting the error posted down below. I used the script ClubAdd.exe from MSDN to add the club tables to my SQL2000 database. I noticed in the error it is looking for dbo.Events and dbo.Locations. These tables exists in my database. However, the tables the owner is not dbo but instead my database login name. Is that the reason for the error? I don't think that that matters, but any way I would appreciate your input to this.

    Thanks

     

    Server Error in '/' Application.

    Invalid object name 'dbo.Events'.
    Invalid object name 'dbo.Locations'.

    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.Events'.
    Invalid object name 'dbo.Locations'.

    Source Error:

    An unhandled exception was generated during the execution of the
    current web request. Information regarding the origin and location
    of the exception can     be identified using the exception stack trace below.


    Stack Trace: 

    [SqlException (0x80131904): Invalid object name 'dbo.Events'.
Invalid object name 'dbo.Locations'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +785922
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +684534
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +207
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, 

            BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1751
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +37
   System.Data.SqlClient.SqlDataReader.get_MetaData() +58
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +213
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
                  Boolean async) +570
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
                      String method, DbAsyncResult result) +134
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 
                   String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, 
             IDbCommand command, CommandBehavior behavior) +141
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, 
             CommandBehavior behavior) +137
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1837
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +129
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
   System.Web.UI.WebControls.GridView.DataBind() +4
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
   System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
   System.Web.UI.Control.EnsureChildControls() +87
   System.Web.UI.Control.PreRenderRecursiveInternal() +41
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Control.PreRenderRecursiveInternal() +161
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1787

    Club Site Starter Kit ASP.NET 2.0

    http://www.rohitjain.com

  • Re: DB error: Invalid object name 'dbo.Events'

    05-09-2007, 3:40 AM
    • Member
      42 point Member
    • iperez_genius
    • Member since 02-11-2006, 10:16 AM
    • Australia
    • Posts 206

    not working for me...

    when i replaced all the dbo. i foujnd they were all located in the xsd sheet.

    I didn't find them anywhere else expect in the stored procedures...which after i changed the procedure it wouldn't let me save... 

     Does anyone have a solution for me?

     

    Ilan
     

    Ilan Perez
    web Developer | Designer

  • System.Data.SqlClient.SqlException: Invalid object name 'frontpagedata'

    06-08-2007, 9:41 AM

    Server Error in '/' Application.

    Invalid object name 'frontpagedata'.

    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 'frontpagedata'.
     

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace: 

    [SqlException: Invalid object name 'frontpagedata'.]
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +45
   TBZOnline.Components.Database.GetDataReadFromQry(String strQry) in c:\inetpub\wwwroot\DotNetCSharp\shaze_2\Components\Database.cs:311
   TBZOnline.Components.frontpageData.GetFrontPageData() in c:\inetpub\wwwroot\DotNetCSharp\shaze_2\Components\Product.cs:525
   tbzOnline.Default.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\DotNetCSharp\shaze_2\Default.aspx.cs:85
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750


    Version Information: Microsoft .NET Framework Version:1.1.4322.2379; ASP.NET Version:1.1.4322.2379

  • Re: DB error: Invalid object name 'dbo.Events'

    05-01-2009, 1:01 AM
    • Member
      13 point Member
    • rogriall79
    • Member since 04-24-2009, 10:34 PM
    • Posts 18

     I am having similiar problems, when I try to check out my pages that have DB in them I get this:

    Invalid object name 'Brands'.

    Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'Brands'.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
      

    [SqlException (0x80131904): Invalid object name 'Brands'.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
       System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
     ect. on the stack trace.  Now Brands is the name of my table and it is supposed to display my products.  Not sure why this isn't working.  It works fine in my local host. 

    Any help would be great.

    Thanks

    Rich

     

  • Re: DB error: Invalid object name 'dbo.Events'

    10-03-2009, 11:19 AM
    • Member
      30 point Member
    • RajibRoy
    • Member since 07-15-2008, 11:48 AM
    • Dubai, UAE
    • Posts 40

    Hi,

    This problem happen specially when you are restoring databse to another server and if you have changed the databse username.

    To solve this problem the best way is to change all SCHEMA to dbo.

    To change SCHEMA execute following code through your MSSQL Enterpeise manager

    ALTER SCHEMA dbo TRANSFER oldSchema.TableName

    If it is working for you give me a thanks


    Rajib Roy

    Sr. Programmer

    Web Planner

    Dubai, U.A.E

    www.seo-mama.com

    www.khonz.com
Page 1 of 1 (14 items)
RSS Available

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.