Vb.net on running shows updation exception
- by harun123
I've a website in vb.net. While running the website i get the following error:
"Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype."
My DB connection.inc file looks as follows:
<%@ Import namespace="ADODB" %
Dim strDataSource As String
Dim cnnCRM As ADODB.Connection
<%
cnnCRM = New ADODB.Connection
strDataSource = Server.MapPath(".") & "/database/crm.mdb"
'strDataSource="c://crm/crm.mdb"
cnnCRM.Open("PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & strDataSource)
%
I've tried giving the record set object all the properties it required. Still the same error. Can anybody tell me how i can get rid of this error?.....