Connecting to Access Database ASP.NET

[NewsBot]

Hello all.

I am having a bit of trouble connecting to my access database.

*** Public Sub ReturnUsers(ByVal connectionString As String)
******* Dim queryString As String = "SELECT * FROM users;"
******* Using connection As New Data.SqlClient.SqlConnection(connectionString)
*********** Dim command As New Data.SqlClient.SqlCommand(queryString, connection)
*********** connection.Open()
*********** Dim reader As Data.SqlClient.SqlDataReader = command.ExecuteReader()
*********** Try
*************** While reader.Read()
******************* Console.WriteLine(String.Format("{0}, {1}", _
*********************** reader(0), reader(1)))
*************** End While
*********** Finally
*************** ' Always call Close when done reading.
*************** reader.Close()
*********** End Try
******* End Using
*** End Sub

That's how I'm returning the users in the database. My connection string is : "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("users.mdb")

The error I'm getting is Keyword not supported: 'provider'.

I'm having trouble understanding why it's giving me this error when I got the connectionstring from connectionstrings.com

Any insight would help.

Much thanks and happy holidays.




More...

View All Our Microsft Related Feeds