Member Avatar for snufse

I am building my 1st .asp application and filling a data grid from a Nothwind DB. When I try to open the connection it gives me user log in error. Can anyone guide me here ?? Thank you.

Exception Details: System.Data.OleDb.OleDbException: Login failed for user 'WITHEATH\ASPNET'

Line 44: myConnection.Open()

Here is my code snippet:

VB:
--------------------------------------------------------------------------------
Public myConnString As String = "Provider=SQLOLEDB;Data
Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;"

Public myConnection As New System.Data.oledb.OleDbConnection(myConnString)

myConnection.Open()

mySelectCommand.CommandText = "SELECT * from users"
mySelectCommand.Connection = myConnection
myAdapter.SelectCommand = mySelectCommand
myAdapter.Fill(myDataSet, "users_table")

If Not (IsPostBack) Then
DataGrid1.DataBind()
End If

  • 2 Contributors
  • 1 Reply
  • 124 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by Tekmaven
Member Avatar for Tekmaven

You need to add a username and password to your connection string ;). Either that, or add the user [MachineName]\ASPNET to your SQL Database Security.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.