error Login failed for user 'HOME\ASPNET'
Hi, I have a aspx page that I designed in web matrix and it works fine. however when i try to put it in visual studio I get the following error Login failed for user 'HOME\ASPNET' . While I don't know what that means it sort of looks like it is looking for a database called aspnet. The code for the connection goes as follows and calls the error at objadapter
Dim objConn As New SqlConnection("server = '(local)';trusted_connection = true; database = 'tryagain'")
Dim objAdapter As New SqlDataAdapter("SELECT [tblslots].* FROM [tblslots]", objConn)
Dim Ds As DataSet = New DataSet()
Dim objTable As DataTable
Dim dv As DataView
dim DRow
objadapter.fill(ds,"tblslots")
Any help would be greatly appreaciated
|
