Click to See Complete Forum and Search --> : Database or object is read-only


tox
02-15-2007, 07:05 PM
Hello, I developed the following asp code with one ISP-Streamelinenet; it worked fine, in fact it NEVER failed not once! Then I moved the code to the ISP where it will actually be-Supanames; and it keeps giving me the same error:

Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
/tavialecom/property/enquiry.asp, line 106

Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open "Enquiry", sys_oConn, adOpenStatic, adLockPessimistic, adCmdTable
rs.AddNew <<<-------------------------- line 106
new_id = sys_GetNextID(sys_oConn,"Enquiry","ID",Start_ID)
rs("ID") = new_id
rs("FullName") = strFullName
rs("Fulladdress") = strFullAddress
rs("Telephone") = strTelephone
rs("Email") = strEmail
rs("Fax") = strFax
rs("Enquiry") = strEnquiry
rs("Comments") = strComments
rs("Referrer") = strReferrer
rs("Replyby") = strReplyBy
rs("Date") = Date
rs("Time") = Time
rs.Update
rs.Close
sys_oConn.Close
Set sys_oConn = Nothing

I have no capability to test asp scripts on my PC everything was tested online, its not the code - the code and database was loaded and reloaded several times (adding fields, to tables etc) without ever a problem, until I loaded the finished working website onto SUPANAMES ISP. They use Windows Server 2003 .NET framework enabled server Virtual server type: IIS 6.0.
Please, any ideas ?

Terrorke
02-16-2007, 02:23 AM
It all has to do with permissions.
Maybe you could contact your ISP about it?