80040e10 ERROR!! PLEASE HELP!

gmoney060 · July 15th, 2004, 09:48 PM

Error Meesage:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/test/Admin_Area.asp, line 26

Script:

Code:

<% 'Declares Variables
    Dim dbName
    Dim ObjConn
    Dim TempUser
    Dim Admin

    'Open DSNless connection to the banner database
    dbName = "/fpdb/topsites.mdb"
    ObjConn= "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & Server.MapPath(dbName)

    'Collects Data from URL Address
    TempUser = Request.QueryString("User")

    'Opens the Database
    Set Admin = Server.CreateObject("ADODB.RecordSet")
    Admin.Open "Select * From Users Where Client_Username="&TempUser,ObjConn,1,2
%>

Comments:
If anyone could please help me IT WOULD BE GREATLY APPREACIATED! You can also IM me using AIM at "G Unit2507"

rajanikrishna · July 15th, 2004, 09:57 PM

hi gmoney060,

I think Client_Username is Text datatype.

Select * From Users Where Client_Username='" & TempUser & "'",ObjConn,1,2

happygv · July 17th, 2004, 11:25 PM

Yes, looks like you are missing ' around TempUser variable.

Check this out. No value given for one or more required parameters

Cheers!

_________________________
- Vijay G
Strive for Perfection