我刚开始使用的是microsoft express默认的sql express 2005,现在需要换成sql2000,请问怎么设置?
网上说改成这个样子
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=.;Integrated Security=SSPI;Initial Catalog=aspnetdb;Persist Security Info=True;User ID=sa;Password="
providerName="System.Data.SqlClient" />
</connectionStrings>
错误提示如下:
Server Error in '/Hainan Aloecorp' 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: Child nodes not allowed.Source Error:
Line 186: <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4"
Line 187: type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
Line 188: <providerOption name="CompilerVersion" value="v3.5"/>
Line 189: <providerOption name="WarnAsError" value="false"/>
Line 190: </compiler>
原来连接sql express2005节点设置如下:
<connectionStrings>
<add name="LocalSqlServer" connectionString="data source=.;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true;uid=sa;pwd=;"
providerName="System.Data.SqlClient" />
</connectionStrings>
网上说改成这个样子
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=.;Integrated Security=SSPI;Initial Catalog=aspnetdb;Persist Security Info=True;User ID=sa;Password="
providerName="System.Data.SqlClient" />
</connectionStrings>
错误提示如下:
Server Error in '/Hainan Aloecorp' 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: Child nodes not allowed.Source Error:
Line 186: <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4"
Line 187: type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
Line 188: <providerOption name="CompilerVersion" value="v3.5"/>
Line 189: <providerOption name="WarnAsError" value="false"/>
Line 190: </compiler>
原来连接sql express2005节点设置如下:
<connectionStrings>
<add name="LocalSqlServer" connectionString="data source=.;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true;uid=sa;pwd=;"
providerName="System.Data.SqlClient" />
</connectionStrings>
我要把SQL2005数据库转换成SQL2000版本。
我很头疼
等我把程序都调通了我再来试试,心里一股恶寒还有我这个错误的原因我找到了:我刚开始用sql express 2005的时候装的是3.5,后来换sql2000的时候装的是2.0的。电脑里面保存了几个.net版本,狠狠的鄙视自己一番