I've set up an ASP.NET page reading from a SQL Server Express database on my computer. When I migrate the page to a web server which has the same SQL Server Express setup and database file path, I get the error below. Everything looks fine. I even changed the [local] server path (.\SQLEXPRESS) to an absolute path (EDSERVER\SQLEXPRESS) to see if it would help.
The web.cong files reads
The ASP.NET page reads
The error code reads
Although now that I look at it...I was told .NET 2.0 was loaded on the web server. But the version info on the error says
Could that be it? Or is it something else?
Dawn
The web.cong files reads
Code:
<connectionStrings>
<add name="RISBpolicies" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\policiesSQL.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
The ASP.NET page reads
Code:
<asp:SqlDataSource ID="PFFpolicies" runat="server" ConnectionString="<%$ ConnectionStrings:RISBpolicies %>"
SelectCommand="SELECT * FROM [PFFPolicies] ORDER BY [PageNumber]" ProviderName="<%$ ConnectionStrings:RISBpolicies.ProviderName %>"></asp:SqlDataSource>
The error code reads
Code:
Server Error in '/' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Unrecognized configuration section 'connectionStrings'
Source Error:
Line 1: <configuration>
Line 2: <connectionStrings>
Line 3: <add name="RISBpolicies" connectionString="Data Source=EDSERVER\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\policiesSQL.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
Line 4: providerName="System.Data.SqlClient" />
[red]Source File: D:\web\RISB_SITE\web.config Line: 2[/red]
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
Although now that I look at it...I was told .NET 2.0 was loaded on the web server. But the version info on the error says
Code:
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
Could that be it? Or is it something else?
Dawn