sql连接错误
程序如下：
<%@ Import Namespace = "System.Data.SqlClient "%>
<%@ Import Namespace = "System.Data "%>
<script language = "C# " runat = "server ">
protected void Page_Load(Object sender,EventArgs e)
{
string strConn = " server = (LENOVO-06164154);database = pubs; uid =sa; pwd =admin ";
SqlConnection Conn = new SqlConnection(strConn);
string sql = "select * from Authors ";
SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
DataSet ds = new DataSet();
Comm.Fill(ds, "Authors ");
MyDataGrid.DataSource = ds.Tables[ "Authors "].DefaultView;
MyDataGrid.DataBind();
}
</script>
<asp:DataGrid ID= "MyDataGrid " Runat = "server " />
错误信息如下：
源错误:
行 10： SqlDataAdapter Comm = new SqlDataAdapter(sql,Conn);
行 11： DataSet ds = new DataSet();
行 12： Comm.Fill(ds, "Authors ");
行 13： MyDataGrid.DataSource = ds.Tables[ "Authors "].DefaultView;
行 14： MyDataGrid.DataBind();
源文件: D:\web\dababase\6-02.aspx 行: 12
堆栈跟踪:
[SqlException: SQL Server 不存在或访问被拒绝。]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
ASP._6_02_aspx.Page_Load(Object sender, EventArgs e) in D:\web\dababase\6-02.aspx:12
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
[解决办法]
string strConn = " server = (LENOVO-06164154);database = pubs; uid =sa; pwd =admin ";
====================================================================================
string strConn = " server =LENOVO-06164154;database = pubs; uid =sa; pwd =admin ";
------解决方案--------------------
如果数据库服务器就是本机
string strConn = " server=.;database = pubs; uid =sa; pwd =admin ";
就可以
[解决办法]
server=(local),这样写要加
