Private
Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim ConnStr As StringConnStr = "data source=BRUDC1; " & _
"database=pubs;integrated security=true"
Dim MySqlConn As New SqlConnection(ConnStr)MySqlConn.Open()
Try Dim SQL As StringSQL = "SELECT * FROM authors FOR XML AUTO, XMLDATA"
Dim mySqlCmd As New SqlCommand(SQL, MySqlConn) Dim MyDS As New DataSetMyDS.ReadXml(mySqlCmd.ExecuteXmlReader(), _
XmlReadMode.Fragment)
XmlDisplay.DocumentContent = MyDS.GetXml()
FinallyMySqlConn.Close()
End Try End SubWhen opening my web form with my browser I get an error message in
subject line.
The security setting on my sql server is set to SQL Server and windows authentication.
IIS and SQL server are running on the same server.
Thanks for any help.
Replies
Know the answer? Post it — somebody with the same question will find it here.