Results 1 to 2 of 2

Thread: ASP ( its urgent )

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2004
    Location
    India
    Posts
    3

    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

  2. #2
    Frenzied Member dj4uk's Avatar
    Join Date
    Aug 2002
    Location
    Birmingham, UK Lobotomies: 3
    Posts
    1,131
    Check that the directory the database is stored in has write permissions.

    DJ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width