NYCPHP Meetup

[Gary Bonde]

Morning  Rinaldy:

The problem you are having is most likely to do with directory/file
permissions on the access database.  If you have control of the webserver
than you need to use windows explorer and give write permissions to the
directory and to the access database .mdb and .ldb.  If you are not in
control of the webserver you will need to ask your hosting provider to
update the permissions.  I have run into this problem a number of times when
using access databases for web development.  Hope this helps.

Gary Bonde
gary at helponboard.org


Date: Fri, 26 Aug 2005 03:01:09 -0700 (PDT)
From: rinaldy roy <rinaldy_roy at yahoo.com>
Subject: [nycphp-talk] Operation must use an updateable query.
To: talk at lists.nyphp.org
Message-ID: <20050826100109.53275.qmail at web52715.mail.yahoo.com>
Content-Type: text/plain; charset="iso-8859-1"

 I've just started my first  HTML and MS Acces as below, but come up with
error:
 

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC
Microsoft Access Driver] Operation must use an updateable query.
/pelanggan_tulis_2.asp, line 20



Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) 


Page:
POST 24 bytes to /pelanggan_tulis_2.asp 


POST Data:
Ipelanggan=aa&Ialamat=bb 
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head>
<title>CekCon</title> </head> <body> <%
ipelanggan=Request("Ipelanggan")
ialamat=Request("Ialamat")
' Set koneksi ke database
Set conn=Server.Createobject( "ADODB.Connection" )
      conn.Mode = 3 ' adModeReadWrite 
   conn.Open "DSN=pelanggan;uid=Admin;pwd=;"
   Set rs = Server.CreateObject("ADODB.Recordset")
   sql="INSERT INTO master_pelanggan(nama_pelanggan, alamat)"
   sql=sql & "VALUES('"& ipelanggan &"', '"& ialamat &"')"
   set RS=Conn.Execute(SQL)
Response.write "data masuk"
%>
</body>
</html>

 
---------------
How to fix it?
 
RRY

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.15/82 - Release Date: 8/25/2005