asp.net中连接不上SQL数据库
求救求救~~TT谢谢!~
Web.config里写的是:
<?xml version="1.0"?>
<!--
有关如何配置 ASP.NET 应用程序的详细信息,请访问
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<connectionStrings>
<add name="LoveAspNet" connectionString="Integrated Security=true;database=LoveAspNet;server=."/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0"/>
</system.web>
</configuration>
DBHelper.cs里写的是:
string connString="";
public DBHelper()
{
connString = WebConfigurationManager.ConnectionStrings["LoveAspNet"].ConnectionString;
}
public SqlDataReader Select(string sql)
{
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);//CommandBehavior.CloseConnection);
return dr;
}
在页面文件中写的是:
string sql = "select* from User where UserName='"+txtName.Text.Trim()+"'";
DBHelper db = new DBHelper();
SqlDataReader dr = db.Select(sql);
连接的时候显示的是:
用户代码未处理 System.Data.SqlClient.SqlException
Message=无法打开登录所请求的数据库 "LoveAspNet"。登录失败。
用户 'thinkpad-THINK\thinkpad' 登录失败。
Source=.Net SqlClient Data Provider
ErrorCode=-2146232060
Class=11
LineNumber=65536
Number=4060
Procedure=""
Server=.
State=1
StackTrace:
在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
在 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
在 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
在 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
在 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
在 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
在 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
在 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
在 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
在 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
在 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
在 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
在 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
在 System.Data.SqlClient.SqlConnection.Open()
在 DBHelper.Select(String sql) 位置 e:\WebSite4\App_Code\DBHelper.cs:行号 32
在 index.btnEnter_Click(Object sender, EventArgs e) 位置 e:\WebSite4\index.aspx.cs:行号 27
在 System.Web.UI.WebControls.Button.OnClick(EventArgs e)
在 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
在 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
在 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
在 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException:
我应该怎么做啊???TT谢谢 --------------------编程问答-------------------- Integrated Security=true;database=LoveAspNet;server=.
换个用户试试
Data Source=.;Initial Catalog=LoveAspNet;User id=sa;pwd=你的sa用户密码 --------------------编程问答-------------------- 建议是指定用户跟密码访问 --------------------编程问答-------------------- 看看你SQL SERVER的服务是否启动?? --------------------编程问答-------------------- 给你个建议啊:首先检查sql服务器是否启动了!然后呢,在检查一下你的连接字符串是否有问题,上面有跟你说怎么用的了,就不用我说的了,如果连接字符创没有问题,那就可能是你连接字符串中的数据库实例不对 --------------------编程问答-------------------- 偶用这样的串连着很正常:
<connectionStrings>
<add name="sqlserver" connectionString="user id=sa;password=123;database=mydb;server=(local)" />
</connectionStrings>
--------------------编程问答--------------------
将server=.换成server=(local)试试 --------------------编程问答-------------------- <connectionStrings>
<add name="SQLCONNECTIONSTRING" connectionString="data source=TANSY-PC\SQLEXPRESS;uid=sa;pwd=888;database=BOCSCTEST" providerName="System.Data.SqlClient"/>
</connectionStrings>
注:TANSY-PC\SQLEXPRESS是我的数据库服务器名称
冒死把我的密码都给出啦, --------------------编程问答-------------------- 调试一下! --------------------编程问答-------------------- 将server=.换成server=(local)试试
补充:.NET技术 , ASP.NET