ASP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Smotherman - 29 Nov 2003 13:31 GMT

Since IE 6.0 came out, whenever anyone tries to order from my website needfultoys.com they get the following message
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/needfultoys_secure/Shipping.asp, line 162
My site is written in ASP of which I am totally ignorant. Is there something I can do or am I going to have to invest in a website written in a different language (which being a struggling business is not in my budget). I have done some (self taught) web development needfulplanet.com for examples but I do not know ASP can anyone help?

Reply to this Message

Jos - 29 Nov 2003 19:12 GMT

> Since IE 6.0 came out, whenever anyone tries to order from my website
> needfultoys.com they get the following message:
[quoted text clipped - 9 lines]
> not in my budget). I have done some (self taught) web development
> needfulplanet.com for examples but I do not know ASP can anyone help?

This problem probably has nothing to do with ASP.
It is usually caused by incorrect security settings for the database
file (mdb file).

Make sure that the user IUSR_MACHINENAME (replace
MACHINENAME with the real name of the server) has write access
to the database.

Signature

Jos

Reply to this Message

Bhaskardeep Khaund - 29 Nov 2003 20:16 GMT

Hi,

This is an error for using not using the appropriate cursor type. Make sure you have used the proper cursor type when you are opening the recordset. Its a simple problem and you can change the recordset by writing a single line like-

Set objRs = Server.CreateObject("ADODB.Recordset")
objRs.CursorType = adOpenStatic (you need to change this to appropriate cursor type)
objRs.Open sql, objConn

Read about the different cursor types in this site:-
http://www.devguru.com/Technologies/ado/quickref/recordset_cursortype.html

Hope this helps,

Regards
Bhaskardeep Khaund

Reply to this Message

ASP

Free Magazines