IIS settings

[TheCandyman]

I have a server with IIS 5 and the correct setting to allow an ASP page to update an Access DB. but im not that good with IIS 4. i know they are very similar, but i must have missed something, the code the works fine on IIS 5 don't work on 4. I get this error. How do i allow updates by all?

Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/login/Password_create.asp, line 24

 

[daveigh]

try to debug whether:
* the connection to the database is correct
* The permissions that are set on the directory the database is in. IUSR privileges must be set to "read/write".
* the database is not corrupt
* response.write the lines before line 24 so you can detect.

see this link:

http://www.xlinesoft.com/asprunner/docs/error_operation_must_use_an_updateable_query.htm

_______________CRYOcoustic_____________

 

[Michael42]

It can also be helpful to ensure you have MDAC 2.5 installed. This allows access to Access 97\2000 database files.


You may have to re-apply it if you installed new software.


Thanks,

Michael42

 

[GaryC123]

Better still mdac 2.7 which is the latest drivers.

http://www.intouchmedialtd.com

 

[TheCandyman]

How do i install the MDAC? The ISP for this client is using the IIS 4, so i wanted to be able to tell "where to go". hehe

 

[GaryC123]

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en

http://www.intouchmedialtd.com