I developed an application for a client that works perfectly on my win2k 
server.  I moved the exact same code to a webhost in the Uk where my 
client bought a space for his site.

When i try to login i get :

Microsoft JET Database Engine error '80040e10' 

No value give for one or more param.....

error in sublogon.asp line 17, which reads :

16...	strSql = "SELECT userid from users WHERE user='" & Session("User") 
& "';"
17...	set rschk = db.execute(strSql)

this is the code in the sub to check the user against the dbase.  where a 
session is created using a random function.

Has anyone ever had this problem???

www.adopenstatic.com/faq/80040e10.asp

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "marcio valenzuela" <mvalenzuela@m...>
Subject: [asp_database_setup] No value given for one...on and off


: I developed an application for a client that works perfectly on my win2k
: server.  I moved the exact same code to a webhost in the Uk where my
: client bought a space for his site.
:
: When i try to login i get :
:
: Microsoft JET Database Engine error '80040e10'
:
: No value give for one or more param.....
:
: error in sublogon.asp line 17, which reads :
:
: 16... strSql = "SELECT userid from users WHERE user='" & Session("User")
: & "';"
: 17... set rschk = db.execute(strSql)
:
: this is the code in the sub to check the user against the dbase.  where a
: session is created using a random function.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~