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

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.

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

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.

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.

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

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.

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.

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

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