Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. 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 Databases 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
  #1 (permalink)  
Old December 9th, 2003, 01:53 PM
Registered User
 
Join Date: Dec 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Microsoft JET Database Engine error '80040e10'

Here is my SQL statement:
SELECT FIELD1, FIELD2, FIELD3, FIELD4, FIELD5, FIELD6, FIELD7, FILENAME, DATE, DIRECTORY, PAGES FROM MTRWEB WHERE LEFT(FIELD1, 3) LIKE '%123%' ORDER BY FIELD1 DESC;

Here is the error I get:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/mtrengine/search.asp, line 397

Line 397 is the following:
objPagingRS.Open strMtrSQL, objPagingConn, adOpenStatic, adLockReadOnly, adCmdText

This code has worked on my 2000 WS machine, the NT Server I have set up in the office, and with other machines I've tested it on. It is not working on the NT Web Server it has to run on. The above error is given. Why would there be no problems on every other machine but this one? Is there something that should be installed? Please help.

Thanks,
Matt Sherman



  #2 (permalink)  
Old December 9th, 2003, 04:30 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Maybe you're using an old ADO version that still uses the * as a wild card. Try replacing the % character with a * and see if that works....

Also, make sure that adOpenStatic, adLockReadOnly, adCmdText etc are declared. Where do they get their values? Maybe the other servers had them defined in global.asa?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
  #3 (permalink)  
Old December 9th, 2003, 04:43 PM
Registered User
 
Join Date: Dec 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the reply. I really thought that that might be it. Unfortunately, I tried and it did the same thing. I do have a suspicion that something is probably not up to date on this server, but I'm not quite sure what it could be. Any thoughts?

By the way, adOpenStatic, adLockReadOnly, and adCmdText are declared. I include the ADOVBS.INC file at the top of the .asp file. Please let me know if you have any other thoughts.

Thanks,
Matt

  #4 (permalink)  
Old December 9th, 2003, 04:50 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

You may want to check out this FAQ: http://www.adopenstatic.com/faq/80040e10.asp although it may not help as the code runs fine on another machine.

What datatype is Field1? Also, what happens if you drop the Left (FIELD1) temporarily and use LIKE just like that?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
  #5 (permalink)  
Old December 9th, 2003, 04:52 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

One more things: DATE may be a reserved word. Are you trying to retrieve a column called Date, or are you trying to get the value of the current dat using the Date function?

In the first scenario, consider renaming the column to something more appropriate.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
  #6 (permalink)  
Old December 9th, 2003, 06:21 PM
Registered User
 
Join Date: Dec 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

To your second post, I have tried that, no luck. To your third post DATE is a column in the database. I don't think, and am pretty sure that it's not a reserved word. I'll check though. I'm still stumped. I installed MDACSDK 2.6 on the server, no luck there. Any other thoughts will be greatly appreciated.

Thanks,
Matt

  #7 (permalink)  
Old December 9th, 2003, 06:31 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Date is definitely a reserved word in Microsoft Access. The VBA language uses Date to get the current date.

So, SELECT MyColumn, Date() FROM aTable

should retrieve the column MyColumn and the current date. For this to work, you need the parentheses, so maybe omitting them makes it work as a column. Check out the list of reserved keywords:

http://support.microsoft.com/default...NoWebContent=1

Did you try to copy and paste the query in Access at the server? Does it run OK there? I am about to get stumped here (or we are overlooking something big here....)

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
  #8 (permalink)  
Old December 9th, 2003, 06:38 PM
Registered User
 
Join Date: Dec 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm not using an access database, it's a dBase database. I know I didn't mention that. But like I said earlier, I don't have any problems with it on my development system, nor on my test server. Only on this one particular server.

  #9 (permalink)  
Old December 9th, 2003, 06:44 PM
Registered User
 
Join Date: Dec 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just to let you know. I did test the query without the "DATE" parameter. Same error.

  #10 (permalink)  
Old December 10th, 2003, 01:57 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Sydney, NSW, Australia.
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Common causes of 80040e10 errors are detailed on my FAQ page:
http://www.adopenstatic.com/faq/80040e10.asp
which Imar has previously posted. Can you please check that the databases on all the servers are exactly the same? You don't have a different version of the database on the troublesome server? You don't have different data on the troublesome server?

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com


Similar Threads
Thread Thread Starter Forum Replies Last Post
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 '80040e10' froggzrevenge Classic ASP Databases 2 January 10th, 2005 12:44 AM
Microsoft JET Database Engine error '80040e10' waynehultum Classic ASP Databases 15 August 20th, 2004 10:22 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.