急!一个连接SQL数据库的问题请教?
y_s_y 2002-12-02 09:49:10 我连接访问SQL SERVER数据库用以下代码:
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%@ Page Language="VB" Debug="true" %>
<html>
<head>
<title>Untitled Document</title>
<Script Language="VB" Runat="Server" >
Dim Sqlserver As String
Dim Myconnection as SqlConnection
Sub Page_Load(Mylogion As Object, E As EventArgs)
Sqlserver="server=ysy;uid=sa;pwd=;database=TEST"
Dim Selstr as string="Select * from USERS"
Myconnection= new SqlConnection(SqlServer)
Dim MyCommand as SqlCommand=new SqlCommand(Selstr,MyConnection)
MyConnection.Open()
......
可是访问该网页总是出现出错页面,显示:
“/web”应用程序中的服务器错误。
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
源错误:
行 17: MyConnection.Open()
总说sa用户不能连接。可是书上也是这样写的呀?而且,SQL SERVER的Secuity下的logins中的sa,我改过几次密码并在代码中也写入了,但仍不行。
请各位前辈多多指教!