Reply

ferdz

Member

40 Points

DB error: Invalid object name 'dbo.Events'

May 09, 2005 09:07 PM|LINK

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

Edited by ferdz on May 09, 2005 09:12 PM

Reply

ferdz

Member

40 Points

8 Posts

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

May 10, 2005 10:00 PM|LINK

bump. Anyone? Help!

Reply

ferdz

Member

40 Points

8 Posts

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

May 13, 2005 02:48 PM|LINK

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 [:$] )

Edited by ferdz on May 13, 2005 02:51 PM

Reply

jdub12

Member

292 Points

67 Posts

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

Jun 13, 2005 05:44 AM|LINK

edit all the queries in the db to have dbo. in the front or the pages aspx pages themselves?

Reply

Fleck

Member

25 Points

5 Posts

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

Jun 24, 2005 09:35 PM|LINK

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

Reply

ferdz

Member

40 Points

8 Posts

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

Jul 06, 2005 07:32 PM|LINK

Hey Jdub,
I edited the .aspx files.

Reply

ferdz

Member

40 Points

8 Posts

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

Jul 06, 2005 07:34 PM|LINK

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

Reply

Fleck

Member

25 Points

5 Posts

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

Jul 10, 2005 12:54 PM|LINK

That did it. Much appreciated

Thank you,

Fleck

Reply

beta_2

Member

25 Points

5 Posts

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

Dec 20, 2005 04:38 PM|LINK

Works great! Thanks for posting your solution. Thats what these forums are for. Take care.

Reply

btech_rohit

Member

25 Points

5 Posts

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

Dec 30, 2005 05:05 PM|LINK

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

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

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

15 replies

ferdz

DB error: Invalid object name 'dbo.Events'

Server Error in '/' Application.

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

ferdz

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

ferdz

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

jdub12

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

Fleck

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

ferdz

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

ferdz

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

Fleck

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

beta_2

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

btech_rohit

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

ferdz

Server Error in '/' Application.

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

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft

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

15 replies

DB error: Invalid object name 'dbo.Events'

Server Error in '/' Application.

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

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

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

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

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

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

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

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

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

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

ferdz

Server Error in '/' Application.

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

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

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

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