A
Andy Monk
Hi
I have some simple VB.NET code to access a DB (the code is below).
BUT, I'm getting a dialog box asking for the Network Password, which doesn't
accept anything I enter, then after 3 attempts resolves to a 'Server Error
401.3' error with the following text:
"Access is denied due to NT ACLs on the requested file."
Now, before starting access to my Sql Server with the code below, I didn't
have a problem...
Any ideas?
Code:
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="system.data.sqlclient" %>
<script runat="server">
' retrieve data from parent_menu table
Sub Page_Load
Dim conString, cmdRetrieve,dtrRead
conString = New
SqlConnection("Server=localhost;uid=sa;password=;database=varsatel")
conString.Open()
cmdRetrieve = New SqlCommand("SELECT * FROM parent_menu",conString)
dtrRead = cmdRetrieve.ExecuteReader()
While dtrRead.Read
Response.Write("<a href=""#"">" + dtrRead("title") +
"</a> ")
End While
dtrRead.Close()
conString.Close()
End Sub
</script>
I have some simple VB.NET code to access a DB (the code is below).
BUT, I'm getting a dialog box asking for the Network Password, which doesn't
accept anything I enter, then after 3 attempts resolves to a 'Server Error
401.3' error with the following text:
"Access is denied due to NT ACLs on the requested file."
Now, before starting access to my Sql Server with the code below, I didn't
have a problem...
Any ideas?
Code:
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="system.data.sqlclient" %>
<script runat="server">
' retrieve data from parent_menu table
Sub Page_Load
Dim conString, cmdRetrieve,dtrRead
conString = New
SqlConnection("Server=localhost;uid=sa;password=;database=varsatel")
conString.Open()
cmdRetrieve = New SqlCommand("SELECT * FROM parent_menu",conString)
dtrRead = cmdRetrieve.ExecuteReader()
While dtrRead.Read
Response.Write("<a href=""#"">" + dtrRead("title") +
"</a> ")
End While
dtrRead.Close()
conString.Close()
End Sub
</script>