update success on local but not at remote

Results 1 to 3 of 3

Thread: update success on local but not at remote

  1. #1
    Join Date
    Dec 1969
    Posts
    940

    Default update success on local but not at remote

    dear all<BR> update problem, <BR>I have tested that my source can run successfully on the local computer at personal web server, but when i upload it to the host server, the problem has occur, the program get the error whenever the update statement is run. my source code is<BR><BR>dim conn<BR>dim rs<BR>dim strID<BR><BR>set conn = server.createobject("adodb.connection")<BR>conn.op en strconn<BR>set rs = server.createobject("adodb.recordset")<BR>rs.open "tblAdoAdd", conn, 2, 2<BR>rs.addnew<BR>rs("FirstName") = request("FirstName") <BR>rs("LastName") = request("LastName")<BR>rs("FavoriteColor") = request("FavoriteColor") <BR>rs.update<BR><BR>when the program is running to rs.update, it occur error<BR><BR><BR><BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    2,437

    Default Which error?

    Could you please divulge the error message that occurs?

  3. #3
    Join Date
    Dec 1969
    Posts
    940

    Default RE: Which error?

    The error is<BR><BR>Microsoft OLE DB Provider for Drivers (0x80004005)<BR>[Microsoft][ODBC Microsoft Access Driver] Cannot update.<BR>Database or object is read-only

Posting Permissions

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