Databases
StackOverflow2013
Postsdbo
POWhy I don't have data from the database?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy I don't have data from the database?
    text
    copied!<p>I am developing an ASP.NET web-based application and I am using a Telerik tool with it. Everything works fine even in the production server in my company. Now, we have another server that we are using it for testing the web-based applications that we are developing. I copied my application including its database from the production server to this testing server, but it did not work well on it. it opens the website but there is no data from the database and I don't know why? I have the <code>connectionstring</code> in the web.config file and I have the same things that are in the production server but still there is no data.</p> <p>I did not change anything in the application and I am using .NET 4 and it is installed in the both servers. Everything is the same but I don't know why I am getting this error. Do you have any solution to this problem?</p> <p><strong>Why the application works in the first server and does not work in the second one?</strong></p> <p>My web.config file is:</p> <pre><code>&lt;configuration&gt; &lt;connectionStrings&gt; &lt;add connectionString="Data Source=localhost\sqlexpress;Initial Catalog=PMODServices;Integrated Security=True" name="PMODServicesConnectionString" providerName="System.Data.SqlClient" /&gt; &lt;/connectionStrings&gt; &lt;system.web&gt; &lt;customErrors mode="Off" /&gt; &lt;compilation debug="true" targetFramework="4.0"&gt; &lt;assemblies&gt; &lt;add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /&gt; &lt;add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /&gt; &lt;add assembly="System.Speech, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" /&gt; &lt;add assembly="System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" /&gt; &lt;add assembly="System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /&gt; &lt;add assembly="System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /&gt; &lt;add assembly="System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /&gt; &lt;add assembly="System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /&gt; &lt;add assembly="System.Data.DataSetExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /&gt; &lt;add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /&gt; &lt;add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /&gt; &lt;add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /&gt; &lt;add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /&gt; &lt;!-- &lt;add assembly="office, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"/&gt; --&gt; &lt;add assembly="stdole, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /&gt;&lt;/assemblies&gt; &lt;buildProviders&gt; &lt;add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /&gt; &lt;/buildProviders&gt; &lt;/compilation&gt; &lt;httpHandlers&gt; &lt;!-- &lt;add path="Telerik.Web.UI.WebResource.axd" verb="*" type="Telerik.Web.UI.WebResource" validate="false" /&gt;--&gt; &lt;add path="Telerik.Web.UI.WebResource.axd" verb="*" type="Telerik.Web.UI.WebResource, Telerik.Web.UI" validate="false" /&gt; &lt;add path="ChartImage.axd" verb="*" type="Telerik.Web.UI.ChartHttpHandler" validate="false" /&gt; &lt;add path="Telerik.Web.UI.SpellCheckHandler.axd" verb="*" type="Telerik.Web.UI.SpellCheckHandler" validate="false" /&gt; &lt;add path="Telerik.Web.UI.DialogHandler.aspx" verb="*" type="Telerik.Web.UI.DialogHandler" validate="false" /&gt; &lt;add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.RadUploadProgressHandler" validate="false" /&gt; &lt;add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false" /&gt; &lt;/httpHandlers&gt; &lt;authentication mode="Windows"/&gt; &lt;pages&gt; &lt;controls&gt; &lt;add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI" /&gt; &lt;/controls&gt; &lt;/pages&gt; &lt;httpModules&gt; &lt;add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" /&gt; &lt;add name="RadCompression" type="Telerik.Web.UI.RadCompression" /&gt; &lt;/httpModules&gt; &lt;/system.web&gt; &lt;location path="Users/Telerik.Web.UI.WebResource.axd"&gt; &lt;system.web&gt; &lt;authorization&gt; &lt;allow users="*"/&gt; &lt;/authorization&gt; &lt;/system.web&gt; &lt;/location&gt; &lt;location path="Telerik.Web.UI.WebResource.axd"&gt; &lt;system.web&gt; &lt;authorization&gt; &lt;allow users="*"/&gt; &lt;/authorization&gt; &lt;/system.web&gt; &lt;/location&gt; &lt;system.webServer&gt; &lt;validation validateIntegratedModeConfiguration="false" /&gt; &lt;handlers&gt; &lt;remove name="ChartImage_axd" /&gt; &lt;remove name="Telerik_Web_UI_SpellCheckHandler_axd" /&gt; &lt;remove name="Telerik_Web_UI_DialogHandler_aspx" /&gt; &lt;remove name="Telerik_RadUploadProgressHandler_ashx" /&gt; &lt;remove name="Telerik_Web_UI_WebResource_axd" /&gt; &lt;add name="Telerik_Web_UI_WebResource_axd" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" preCondition="integratedMode" /&gt; &lt;add name="ChartImage_axd" path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" preCondition="integratedMode" /&gt; &lt;add name="Telerik_Web_UI_SpellCheckHandler_axd" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" preCondition="integratedMode" /&gt; &lt;add name="Telerik_Web_UI_DialogHandler_aspx" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" preCondition="integratedMode" /&gt; &lt;add name="Telerik_RadUploadProgressHandler_ashx" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" preCondition="integratedMode" /&gt; &lt;add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /&gt; &lt;/handlers&gt; &lt;modules runAllManagedModulesForAllRequests="true"&gt; &lt;remove name="RadUploadModule" /&gt; &lt;remove name="RadCompression" /&gt; &lt;add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" preCondition="integratedMode" /&gt; &lt;add name="RadCompression" type="Telerik.Web.UI.RadCompression" preCondition="integratedMode" /&gt; &lt;/modules&gt; &lt;/system.webServer&gt; &lt;appSettings&gt; &lt;add key="Telerik.ScriptManager.TelerikCdn" value="Enabled" /&gt; &lt;add key="Telerik.StyleSheetManager.TelerikCdn" value="Enabled" /&gt; &lt;/appSettings&gt; &lt;/configuration&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload