ASP Connection Error!

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 (gbutler@bgcpeoria.net)

Mart,

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

GROQ