关于异常的疑难解答：System.InvalidOperationException

[liliyuanshangcao1]

实例失败。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.InvalidOperationException: 实例失败。

源错误:


行 109: SqlDataAdapter dbAdapter = new SqlDataAdapter(sQueryString, con);
行 110: DataSet dataset = new DataSet();
行 111: dbAdapter.Fill(dataset, TableName);
行 112: return dataset;
行 113: }


源文件: e:\Inetpub\wwwroot\OAS\App_Code\BaseClass.cs 行: 111

堆栈跟踪:


[InvalidOperationException: 实例失败。]
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4862691
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +257
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92
BaseClass.GetDataSet(String sQueryString, String TableName) in e:\Inetpub\wwwroot\OAS\App_Code\BaseClass.cs:111
UserControl_GoodEmployee.Page_Load(Object sender, EventArgs e) in e:\Inetpub\wwwroot\OAS\UserControl\GoodEmployee.ascx.cs:17
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


web.config中的数据库配置是
<appSettings>
<add key="conStr" value="Server=.\\SQLEXPRESS ;database=db_OAS;Uid=sa;Pwd=1111111;"/>
</appSettings>
使用工具是VS2008+SQL2005+win7 32位

[bdmh]

确认数据库实例名正确吗，能否正常连接

[liliyuanshangcao1]

这是我的实例名"WIN-VQQI929SG1V\SQLEXPRESS "跟机器名相同
能正常连接

[liliyuanshangcao1]

公共类里设置的数据库查询链接如下
public System.Data.DataSet GetDataSet(string sQueryString, string TableName)
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
SqlDataAdapter dbAdapter = new SqlDataAdapter(sQueryString, con);
DataSet dataset = new DataSet();
dbAdapter.Fill(dataset, TableName);
return dataset;
}

[csover8]

TableName是string类型？

[EnForGrass]

改成下面的连接字符串
<add key="conStr" value="Server=WIN-VQQI929SG1V\SQLEXPRESS ;database=db_OAS;Uid=sa;Pwd=1111111;"/>

[liliyuanshangcao1]

谢谢 5楼，果然调试出来了。就是不知道为什么网上说实例名与机器名相同就可以用.代替。