Help with Server Error in Clubsitehttp://forums.asp.net/t/1045488.aspx/1?Help+with+Server+Error+in+ClubsiteTue, 20 Jul 2010 21:59:07 -040010454881465728http://forums.asp.net/p/1045488/1465728.aspx/1?Help+with+Server+Error+in+ClubsiteHelp with Server Error in Clubsite <p>I am getting the following error what do I need to do?</p> <p><span></p> <h1>Server Error in '/' Application. <hr width="100%" color="silver" size="1"> </h1> <h2><i>The connection name 'ClubSiteDB' was not found in the applications configuration or the connection string is empty.</i> </h2> <p></span><font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "><b>Description: </b>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. <br> <br> <b>Exception Details: </b>System.InvalidOperationException: The connection name 'ClubSiteDB' was not found in the applications configuration or the connection string is empty.<br> <br> <b>Source Error:</b> <br> <br> <table class="" width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td class=""><pre class="prettyprint">The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:<br> <br> 1. Add a &quot;Debug=true&quot; directive at the top of the file that generated the error. Example:<br> <br> &lt;%@ Page Language=&quot;C#&quot; Debug=&quot;true&quot; %&gt;<br> <br> or:<br> <br> 2) Add the following section to the configuration file of your application:<br> <br> &lt;configuration&gt;<br> &lt;system.web&gt;<br> &lt;compilation debug=&quot;true&quot;/&gt;<br> &lt;/system.web&gt;<br> &lt;/configuration&gt;<br> <br> Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.<br> <br> Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.</pre> </TD></TR></TBODY></TABLE><BR><B><FONT face=Verdana>Stack Trace:</FONT></B> <BR><BR> <TABLE class="" width="100%" bgColor=#ffffcc> <TBODY> <TR> <TD class=""><pre class="prettyprint"><PRE>[InvalidOperationException: The connection name 'ClubSiteDB' was not found in the applications configuration or the connection string is empty.] System.Web.Compilation.ConnectionStringsExpressionBuilder.GetConnectionString(String connectionStringName) +2959805 ASP.default_aspx.__BuildControlSqlDataSource1() +96 ASP.default_aspx.__BuildControlContent1(Control __ctrl) +208 System.Web.UI.CompiledTemplateBuilder.InstantiateIn(Control container) +12 ASP.default_master.__BuildControlContentPlaceHolder1() +101 ASP.default_master.__BuildControlform1() +87 ASP.default_master.__BuildControlTree(default_master __ctrl) +193 ASP.default_master.FrameworkInitialize() +34 System.Web.UI.UserControl.InitializeAsUserControlInternal() +31 System.Web.UI.MasterPage.CreateMaster(TemplateControl owner, HttpContext context, VirtualPath masterPageFile, IDictionary contentTemplateCollection) +1980896 System.Web.UI.Page.get_Master() +48 System.Web.UI.Page.ApplyMasterPage() +18 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +543 </PRE></pre></td> </tr> </tbody> </table> <br> </font></p> 2006-11-15T12:55:17-05:001466073http://forums.asp.net/p/1045488/1466073.aspx/1?Re+Help+with+Server+Error+in+ClubsiteRe: Help with Server Error in Clubsite Check your connectingString. Make sure it is pointing to the Club.mdf<br> 2006-11-15T16:53:26-05:001466120http://forums.asp.net/p/1045488/1466120.aspx/1?Re+Help+with+Server+Error+in+ClubsiteRe: Help with Server Error in Clubsite <p>My problem is I have loaded SLQ 2005 and created several databases&nbsp; database1, database2, database3 each of this databases are shown in my server explorer in my VS2005&nbsp; as gremlin.database1.dbo ,gremlin.database2.dbo, and gremlin.database3.dbo also listed are club.mdf and aspnetdb.mdf</p> <p>My current connection strings in vs look like this</p> <font color="#0000ff" size="2"> <p>&lt;</font><font color="#800000" size="2">configuration</font><font color="#0000ff" size="2"> </font><font color="#ff0000" size="2">xmlns</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">http://schemas.microsoft.com/.NetConfiguration/v2.0</font><font size="2">&quot;</font><font color="#0000ff" size="2">&gt;</p> <p>&lt;</font><font color="#800000" size="2">appSettings</font><font color="#0000ff" size="2">/&gt;</p> <p>&lt;</font><font color="#800000" size="2">connectionStrings</font><font color="#0000ff" size="2">&gt; </p> <p>&lt;add name= &quot;3378372ConnectionString&quot; ConnectionString=&quot;Data Source=Gremlin;Intial Catalo=database1;Interated Securiy=True&quot;</p> <p>providerName=&quot;Sytem.Data.SQLClient&quot; /&gt;</p> <p>&lt;</font><font color="#800000" size="2">add</font><font color="#0000ff" size="2"> </font><font color="#ff0000" size="2">name</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">rac_20050428ConnectionString1</font><font size="2">&quot;</font><font color="#0000ff" size="2"> </font><font color="#ff0000" size="2">connectionString</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">Data Source=Gremlin;Initial Catalog=database2;Integrated Security=True</font><font size="2">&quot;</p> </font><font color="#0000ff" size="2"> <p></font><font color="#ff0000" size="2">providerName</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">System.Data.SqlClient</font><font size="2">&quot;</font><font color="#0000ff" size="2"> /&gt;</p> <p>&lt;</font><font color="#800000" size="2">add</font><font color="#0000ff" size="2"> </font><font color="#ff0000" size="2">name</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">racConnectionString1</font><font size="2">&quot;</font><font color="#0000ff" size="2"> </font><font color="#ff0000" size="2">connectionString</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">Data Source=Gremlin;Initial Catalog=database3;Integrated Security=True</font><font size="2">&quot;</p> </font><font color="#0000ff" size="2"> <p></font><font color="#ff0000" size="2">providerName</font><font color="#0000ff" size="2">=</font><font size="2">&quot;</font><font color="#0000ff" size="2">System.Data.SqlClient</font><font size="2">&quot;</font><font color="#0000ff" size="2"> /&gt;</p> <p>&lt;/</font><font color="#800000" size="2">connectionStrings</font><font color="#0000ff" size="2">&gt;</font></p> <p><font color="#0000ff" size="2">I also have a connection string that pathed to sqlexpress that was loaded at the time of download of the clubsite. It has the club.mdf included</font></p> <p><font color="#0000ff" size="2"></font>&nbsp;</p> <p><font color="#0000ff" size="2">Any suggestions</p> </font> 2006-11-15T17:23:27-05:003983085http://forums.asp.net/p/1045488/3983085.aspx/1?Re+Help+with+Server+Error+in+ClubsiteRe: Help with Server Error in Clubsite <p>Does anyone have an answer to this question.&nbsp; I am getting the exact same error message after moving&nbsp;a website&nbsp;into &quot;unlimited&quot; hosting on Godaddy under another website (primary).</p> <p>&nbsp;</p> <p>The error is coming from the content page default.aspx at the following line</p> <p>&lt;asp:SqlDataSource ID=&quot;SqlDataSource1&quot; runat=&quot;server&quot; ProviderName=&quot;System.Data.SqlClient&quot;<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ConnectionString=&quot;&lt;%&#36; ConnectionStrings:ClubSiteDB %&gt;&quot; SelectCommand=&quot;SELECT top 5 [id], [itemdate], [title], [description], [photo] FROM [Announcements] order by itemdate desc&quot;&gt;<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/asp:SqlDataSource&gt;</p> <p>Can anyone help?&nbsp; Thanks, Bev<br> &nbsp;</p> 2010-07-20T21:59:07-04:00