Save To Database !

[evgin]

Pls, help me!

the code is this:

<%
plantermin=request.form("plantermin")
musteri=request.form("musteri")
siparis_no=request.form("siparis_no")
renk=request.form("renk")
siparis_adet=request.form("siparis_adet")
plan_adet=request.form("plan_adet")
aciklama=request.form("aciklama")

Set Baglanti = Server.CreateObject("ADODB.Connection")
cnnTip = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:/INETPUB/WWWROOT/dbase/dbase.MDB"
'cnnTip = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="
'cnnYol = Server.MapPath("mydb/vt1.mdb")
'Baglanti.Open (cnnTip & cnnYol)
Baglanti.Open (cnnTip)

SQLstmt = "INSERT INTO haftalik_tablo(plantermin, musteri, siparis_no, renk, siparis_adet, plan_adet, aciklama)"
SQLstmt = SQLstmt & " values('" & plantermin & "','" & musteri & "','" & siparis_no & "','" & renk & "','" & siparis_adet & "','" & plan_adet & "','" & aciklama & "')"

Baglanti.Execute (SQLstmt)
Baglanti.Close
Set Baglanti = nothing

Response.write "<br><br><center><b>OK !</b></center>"
%>


But it is giving allways the same error. pls help me!
it says that "the query must be updatable"

What can I do? Iam using WinXP pro and Office XP

[rdoekes]

Make sure your database is not read-only and that the IUSR_[servername] has modify rights for the dabase.

In short. Go to the folder where the database resides with Windows Explorer, right click op de database, properties, security. Make sure the internet user has full control over this file.

-Rogier

[evgin]

I sent the script code and the db files to my friend. He said that the code is running on Win2000 pro. I think there is a problem with my os that is WinXP pro. What can be ?

[evgin]

Also, I did that:

E:\inetpub\wwwroot\db\vt1.mdb /G everone:F

but it did not be solution! I have still the same problem

[evgin]

I am very upset Dave,

I tried the codes which you wrote. But I got the same error message again. it shows line 11. (myRst.Open SQLstmt, myConn, 2, 3)


Pls someone help me!

[evgin]

I am doing an intranet for the company and the files in


E:\inetpub\wwwroot\AYDINEL03\

[evgin]

I am the administrator and using IIS on WinXP pro.

[evgin]

hi Dave,

I have already tried what you said but unfortunately that I have got the same error again.

I wanted to send you the folder, you may try on your computer. But I could not find your email adres to send it.


I want to ftp to http://bornova.ege.edu.tr/~evgin but I am very surprised that after I delete the index.html file again the file can be seen on the address. But infact there is not any file called index.htm on the server for the address.

OOOOOOOOFFFFFFFFFFFFF OOOOOOOOOFFFFFFFFFFF!

[evgin]

if I right click on the folder which is in the wwwroot directory, I could not find the "security" tab. there is "sharing and security" tab. when I click on it then sharing buton is opened. there is two check box one is "read only" other is "secret". I tried all alternatives on the properties page. But I could not solve.

I am reading the IIS info now. I sent my folder to a friend who is using Winxp pro and IIS like me. He tried after clicking on the permission wizard from IIS. He said that it is working on his computer now. But I have not done yet. I am reading info from help documents of IIS.

[evgin]

open IIS, right click then open all task you can see the first tab.

How can solve the other problem, chash problem??