Invalid object name 'Announcements' [Archive]

snjnjnpl

05-17-2006, 08:01 AM

I'm a complete beginner with SQL Server. I'm trying to put theClub Website Starter Kit on discountasp. I have looked at tons of blogs, messageboards, etc, including numerous ones within discountasp's site. A lot of the postings I find "assume" you know how to do things with SQL Server. I'm trying to learn, but it hasn't been easy so far. I amusing VS2005, SQL Server 2005 with the SQL Server Management Studio.

I've learned how to connect discountasp.net SQL Server so I don't think there isremote server connection problems. But I don't know where I missed because I get error message like the following when I put "Ctrl F5".
I typed in theline as instructed in this forum, replacing connectionString part.(see my web.config file below after error message):
<SUB>
I must be missing a step (or steps) along the way because I keep gettingthis kind oferrors. I hope one of you guys will point out my mistake. I tried over and over in so manyways for about one month, but only getting errors to making discourage. Please help me. Let me payif needed. Maybe you can supply me with right sample code which realy works. Please contact me. My email address is "snjnjnpl@gmail.com. I'm looking for helper or tutors who can help me tomake a successfulpublishing about "club and persnal" starter kit.

Server Error in '/CLUB' Application.

Invalid object name 'Announcements'.
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 'Announcements'.

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 'Announcements'.]
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) +177
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +68
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2305
System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +294
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1021
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +314
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +20
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method) +107
System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior behavior) +10
System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior) +7
System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceSelectArguments arguments) +1661
System.Web.UI.WebControls.Repeater.GetData() +50
System.Web.UI.WebControls.Repeater.CreateControlHi erarchy(Boolean useDataSource) +214
System.Web.UI.WebControls.Repeater.OnDataBinding(E ventArgs e) +54
System.Web.UI.WebControls.Repeater.DataBind() +62
System.Web.UI.WebControls.Repeater.EnsureDataBound () +55
System.Web.UI.WebControls.Repeater.OnPreRender(Eve ntArgs e) +13
System.Web.UI.Control.PreRenderRecursiveInternal() +88
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731

++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<location path="events_edit.aspx">
<system.web>
<authorization>
<allow roles="Administrators"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
<location path="locations_edit.aspx">
<system.web>
<authorization>
<allow roles="Administrators"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
<location path="news_edit.aspx">
<system.web>
<authorization>
<allow roles="Administrators"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
<location path="photoalbum_new.aspx">
<system.web>
<authorization>
<allow roles="Administrators"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
<location path="member_list.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
<location path="member_details.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>

<connectionStrings>

<add name="ClubSiteDB" connectionString="Data Source=sql2k503.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_242817_sqldiscount; User ID= SQL2005_242817_sqldiscount_user; Password=0292shm" providerName="System.Data.SqlClient"/>

<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=sql2k503.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_242817_sqldiscount; User ID= SQL2005_242817_sqldiscount_user; Password=0292shm" providerName="System.Data.SqlClient"/>

</connectionStrings>

<system.web>
<roleManager enabled="true"/>
<authentication mode="Forms" />
<compilation debug="false" strict="true">
<assemblies>
<add assembly="System.Xml, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Messaging, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
</assemblies>
</compilation>
<membership defaultProvider="AspNetSqlMembershipProvider"/>
<siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true">
<providers>
<remove name="AspNetXmlSiteMapProvider"/>
<add name="AspNetXmlSiteMapProvider" description="SiteMap provider which reads in .sitemap XML files." type="System.Web.XmlSiteMapProvider" securityTrimmingEnabled="true" siteMapFile="Web.sitemap"/>
</providers>
</siteMap>
<customErrors mode="RemoteOnly" defaultRedirect="ErrorPage.htm"/>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
</system.web>
</configuration>

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