2. ASPRunnerPro General questions
  3. Cant Update records
This topic is locked

Cant Update records

 		1/2/2005 9:26:38 PM
ASPRunnerPro General questions
D
 dsuthar author

I read the FAQ and still dont seem to know why it wont work.
Im using Win2k3 Server. I just created a website in IIS and pointed it to the directory I had ASPrunner make the files on.
Now the page comes up fine and all, but I cant update any records.
Following error appears when I tried a test record.
--------------------------------------

Error number -2147467259

Error description [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

URL /Names_edit.asp

SQL query update [Names] set [Names]='Arvind Person', [# Projected]=5, [Address]='123 USA Drive', [City]='Sometown', [State]='PA', [Zip]='17011', [Phone]='(555) 555-3682', [Remark]='' where [ID]=1

-------------------------------------
Now I saw in the FAQ it talked about editing the connection string but that didnt have a difference. Im not sure if thats necessary since I just created a website in IIS and pointed to that folder, not a virtual directory.
Again here is the connection string file

--------------------------------------

<%

strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("db/test.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"

%>

--------------------------------------
Not sure why I cant do the update, I tried locally from the webserver and from a remote site. Only thing I failed to mention that Im sure makes a difference but its being hosted on port 443 which a self signed cert.
Dixit
Sergey Kornilov admin 1/3/2005

Hi,
this is permissions error. Just give all permissions to Everyone on the folder where database is located.
See the following article, Scenario 2

http://xlinesoft.com/asprunner/docs/troubl...ery__errors.htm
D
 		dsuthar author 1/3/2005

I did that, I gave permissions to everyone group to the entire output folder ASPrunner made. Still no luck.
Sorry I failed to mention this earlier.
Dixit
Sergey Kornilov admin 1/3/2005

Dixit,
that sounds strange. Does it work if you connect to regular HTTP port (80)?
I would recommend to resolve permissions issue first and switch to SSL port after that.
D
 		dsuthar author 1/4/2005

Got it to finally work, but then when I created another project (since the first one was test) it stopped working again.
It definetely isnt port related since It doesnt work on SSL or normal port 80.
Im not sure what the problem is, but I know its defientely permissions. Because thats the only change I made when I got it to work. I give the entire output folder that ASPRunner makes permissions to the EVERYONE group and FULL CONTROL and still no go.
I cant seem to figure out how I got it to work the first few times by doing the same thing.
Dixit
D
 		dsuthar author 1/4/2005

I figured it out. For some reason it has to do with the IIS6 anonymous setting user. Its where its defaults to the ISR_USR account (or however its spelled). I took that off and then when I go to the website it asks me to login, I login'ed as the admin and then the add/edit function worked just fine.
So some reason the everyone group doesnt include that user above. Will do some more digging to find out why.
Dixit