...

Access Problem

Cipher
10-23-2005, 10:10 PM
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?!

vinyl-junkie
10-24-2005, 12:20 AM
Your connection syntax is incorrect. Here is what you need:

Dim Conn As New OleDbConnection( _
"Provider=Microsoft.Jet.OleDb.4.0;" & _
"Data Source=DB\forum.mdb")

Cipher
10-24-2005, 01:38 AM
I restarted my computer and it worked pretty fine,
but 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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum