I'm using Microsoft Access for first time with ASP.NET, i used the same code i use with SQL Server except i changed any Sql to OleDB,
and here's the connection i used:
Dim Conn As New OleDbConnection("Provider=Microsoft.OLEDB.Jet.4.0;Data Source=" & Request.MapPath("DB\forum.mdb"))
but i got that error:
'Microsoft.OLEDB.Jet.4.0' provider is not registered on the local machine
and i'm installing Access ofcourse, so what is that for?!I restarted my computer and it worked pretty fine, there was no problems
well i have another problem, when i try to read from the database it works pretty fine, but when i try to add any new values, it gives me this error:
Operation must use an updateable query.
i use ExecuteNonQuery to add values.
and here's the connection i used:
Dim Conn As New OleDbConnection("Provider=Microsoft.OLEDB.Jet.4.0;Data Source=" & Request.MapPath("DB\forum.mdb"))
but i got that error:
'Microsoft.OLEDB.Jet.4.0' provider is not registered on the local machine
and i'm installing Access ofcourse, so what is that for?!I restarted my computer and it worked pretty fine, there was no problems
well i have another problem, when i try to read from the database it works pretty fine, but when i try to add any new values, it gives me this error:Operation must use an updateable query.
i use ExecuteNonQuery to add values.