"Microsoft OLE DB Provider for ODBC Drivers error

Results 1 to 2 of 2

Thread: "Microsoft OLE DB Provider for ODBC Drivers error

  1. #1
    Join Date
    Dec 1969

    Default "Microsoft OLE DB Provider for ODBC Drivers error

    hey people<BR><BR>i am creating a connection to a microsoft access data base. its s DSN based conection. when i tried to add new record to it and then update it ,it gives me an error like this<BR>"Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only "<BR><BR>i have make my cursor type addynamic and lock type to optimstic.<BR>do i need to specify cursor location or. what .i am using IIS. server.<BR>please help. what can i do<BR>My code is here<BR><BR>&#060;%<BR>Dim objConn<BR>Dim objrs<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>Set objrs = Server.CreateObject("ADODB.Recordset")<BR>Set objComm = Server.CreateObject("ADODB.Command")<BR>objConn.Co nnectionString = "DSN=news1"<BR>objConn.Open<BR>count = 1<BR>objrs.open "Select * from eadd",objconn,2,3<BR>response.write "&#060;ol&#062;"<BR>while not objrs.eof <BR> response.write "&#060;li&#062;"<BR> response.write "&#060;a href=" & objrs("emailadd")& "&#062;" <BR> response.write objrs("emailadd")& "&#060;/a&#062; <BR>" <BR> response.write "&#060;/li&#062;" <BR> response.write "&#060;div align = center&#062;"<BR> response.write "&#060;/a&#062;"<BR> response.write "&#060;/div&#062;"<BR> count = count + 1 <BR> objrs.Movenext<BR>wend <BR>response.write "&#060;/ol&#062;" <BR>tadd = request.form("txteadd")<BR>objrs.movefirst<BR>objr s.addnew<BR>objrs("emailadd") = "Street"<BR>objrs("subid") = count<BR>objrs.update<BR>objrs.close<BR>response.w rite "User Addedd"<BR>%&#062;<BR><BR><BR>thanks in advance

  2. #2
    Mark Guest

    Default RE:

    When I have received that error message, it usually meant that I did not have write permissions on the .mdb file. Since you are using a DSN, make sure it isn&#039t set to read only. Go to Control Panel -&#062; ODBC Data Sources, and "configure" your Data Source. Hit the "Options&#062;&#062;" button and make sure the "Read Only" checkbox is not checked.

Posting Permissions

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