无法访问SQL——新手问题,代码很短,来看一下吧。
<%@ Page Language="vb" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<html>
<script Language="VB" runat="server" >
Sub page_Load(Src As Object,E As EventArgs)
Dim MyConnection As SQLConnection
Dim MyCommand As SQLCommand
MyConnection=New SQLConnection("server=localhost; uid=sa;pwd=;database=Northwind")
MyCommand=New SQLCommand("select * from customers",MyConnection)
MyConnection.open()
Dim DS As SQLDataReader=MyCommand.ExecuteReader()
MyDataGrid.DataSource=DS
MyDataGrid.DataBind()
MyConnection.close()
End Sub
</script>
<body>
<h3><font face="Verdana">Northwind Customers</font></h3>
<ASP:DataGrid id="MyDataGrid" Runat="server" width="700" BackColor="#FFFFFF"
BorderColor="black" ShowFooter="false" CellPadding=3 CellSpacing="0"
Font-Name="Verdana" Font-size="8pt" HeaderStyle-BackColor="#cfcfcf"
EnableViewState="false"/>
</body>
</html>
错误发生在:MyConnection.open()
错误说明:SQL不存在或拒绝访问。
SQL是新装的,并且在vb.net windows application项目中可以访问;
不知道为什么在asp.net中不行