Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 25th, 2006, 03:43 PM
Registered User
 
Join Date: Feb 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error Type:Microsoft JET Database Engine (0x800040

I have tried the code presented in the book Beginning Active Server Pages 3.0 on the chapter 14. The code in question is the SQLUpdate.asp where it tries to update a fields in the movie2000.mdb database. I have tried also the code given for download and I ge the same error message:

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/begASP/SQLUpdate.asp, line 22

Pleas Help I don't know what's wrong.

I have checked the permissions and on both the server and windows are set for read and write

 
Old February 26th, 2006, 10:10 AM
Friend of Wrox
 
Join Date: Nov 2005
Posts: 223
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Stefanoz,

First off all have you created a odbc connection in windows. And are you using Odbc connection code in your asp code.

The reason I ask this is there is a big difference between mysql wich is most common and a acces database wich you are using.

This is what your asp code should look like
Code:
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
%>
Or like this with a odbc connection:
Code:
<%
set conn=Server.CreateObject("ADODB.Connection") 
conn.Open "northwind"
%>
hope this helps

__________________________________________________ ________
This is my junk I'm gona eat it
 
Old February 26th, 2006, 06:07 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

;;;I have checked the permissions and on both the server and windows are set for read and write

Permissions for which user? IUSR privileges must be set to "read/write".


Wind is your friend
Matt





Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Error: Microsoft Jet Engine asters ASP.NET 1.0 and 1.1 Professional 2 April 3rd, 2007 09:33 AM
Microsoft JET Database Engine error '80040e10' byronthurman Classic ASP Databases 5 June 8th, 2006 08:20 AM
Microsoft JET Database Engine error '80040e10' malhyp Classic ASP Databases 5 June 6th, 2006 10:07 PM
Microsoft JET Database Engine error '80040e14' aprnip Classic ASP Databases 6 December 10th, 2005 07:36 AM
Microsoft JET Database Engine error '80040e10' nvillare Classic ASP Databases 1 August 20th, 2003 12:09 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.