Classic ASP Discussion - ASP Connection Error!

Print Page | Close Window

ASP Connection Error!

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=4411
Printed Date: 30 March 2026 at 10:06am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ASP Connection Error!

Posted By: groq
Subject: ASP Connection Error!
Date Posted: 21 July 2003 at 10:55am

Hi,

I keep getting the following error message in my browser when trying to execute the follow code in my .asp page.
---------------------------------------------------------------------------
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/employee.asp, line 26
---------------------------------------------------------------------------

The line of code is as follows:
----------------------------------------------------------------------------------------------------------------
sql = "SELECT LName, FName, Title FROM tblstaff WHERE Emp_Status = 'Active'"
----------------------------------------------------------------------------------------------------------------

This is a DNS-less connection connecting to an Access Database. What exactly am I doing wrong with this code?

Thank you!

GROQ ( mailto:gbutler@bgcpeoria.net - gbutler@bgcpeoria.net )

-------------
GROQ

Replies:

Posted By: Mart
Date Posted: 21 July 2003 at 11:54am

sql = "SELECT * FROM tblstaff WHERE Emp_Status = 'Active';" try that...

Posted By: groq
Date Posted: 21 July 2003 at 2:18pm

Mart,

thanks for the help. I tried your suggestion but no cigar. Same error message. Any more suggestions?

GROQ

-------------
GROQ