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 July 11th, 2004, 06:13 PM
Registered User
 
Join Date: Jul 2004
Location: Richardson, TX, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to byronthurman Send a message via MSN to byronthurman Send a message via Yahoo to byronthurman
Default Microsoft JET Database Engine error '80040e10'

I've been searching all over the net and forums trying to find an answer to this problem. But I can't seem to figure out what the problem is. I keep recieving this error.


Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

vdateUsr.asp, line 47


Here is the code:


' execute sql and open as recordset
sqlStr = "Select * From tUsers where username = '" _
            & Request.Form("username") & "' and password = '" & Request.Form("password") & "'"

' Opens the returned values from the SQL as a recordset, ready for iteration by ASP
set rcSet = cnStr.Execute(sqlStr) // And this is line 47

I have tried checking the delimiters, spacing, everything that I could find a possible problem with, but have still had no luck. However I'm still very new to this and could be on the wrong track totally.

Thanks,


<<<<
Byron Thurman
byronthurman@yahoo.com
  #2 (permalink)  
Old July 11th, 2004, 09:18 PM
Friend of Wrox
 
Join Date: Sep 2003
Location: Mentiri, Muara, Brunei.
Posts: 363
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi,

  Verify the field names. May be password is reserved word

  #3 (permalink)  
Old July 11th, 2004, 09:57 PM
Authorized User
 
Join Date: Feb 2004
Location: , , .
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Check out this Web Site for troubleshooting
http://www.adopenstatic.com/faq/80040e10.asp



  #4 (permalink)  
Old July 12th, 2004, 12:52 AM
Authorized User
 
Join Date: Feb 2004
Location: Karachi, , Pakistan.
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to knight
Default

pls send me strsql this error tell there is no value to
test i mean username and passowrd are empty

try
response.write(ur query variable)
response.end
then post it then i will try 2 resolve it


  #5 (permalink)  
Old July 12th, 2004, 07:38 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Byron Thurman,

Code that contructs sqlstr seems to be fine.

Doesn't look like your query has spelling mistakes too. May be you can check that once if your Table/Column names are spelt correctly in the Query as defined in your database.

Lastly it looks like your USERNAME/PASSWORD values from the FORM is/are not coming through. Check if both contains something in it, before contructing your SQL query.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection
  #6 (permalink)  
Old June 8th, 2006, 08:20 AM
Registered User
 
Join Date: Jun 2006
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

did you ever figure it out.



Similar Threads
Thread Thread Starter Forum Replies Last Post
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' shermttam Classic ASP Databases 9 December 10th, 2003 01:57 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.