|
-
Jul 21st, 2004, 05:59 AM
#1
Thread Starter
New Member
ASP ( its urgent )
Hi everyone
I am having a problem in saving data to Access Database from an ASP page.
I have opened connection to the database through ADODB.Connection.
I have a recordset opened.. ADODB.Recordset
the code seems to be as such :-
dim con
dim rs
dim sql
set con = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
con.Open "Provider=Microsoft..........."
sql = "select * from UserEntry"
rs.CursorType = 2
rs.LockType = 3
rs.Open sql,con
rs.Addnew
rs.Fields("UserName").Value = user.....
........ and so on..
rs.Update
rs.Close
con.Close
But i am getting an error as such that the object or the database is readonly.. i cant avoid this error.. I would await all help regarding this matter..
Thankx.
Nayan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|