Hi all,

I seem to be having a little problem with the below error appearing intermittently on my site, it doesn’t appear all the time, it will maybe only show up 1 in 10 times I visit the page. When I refresh the page it loads ok. I seem to work ok locally on my machine, that's to say I've never seen the error locally. I've searched the forum but can't find a solution.

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/carDetails.asp, line 15
<pre id=code><font face=courier size=2 id=code>&lt;%
set conn = server.createobject("adodb.connection"
dbase = server.mappath("." & "/db.mdb"
conn.open "provider = microsoft.jet.oledb.4.0; data source = " & dbase

SQL = "select * from cars where id = " & request("id"
set rsCars = server.createobject("ADODB.recordset"
rsCars.open SQL, Conn,1,3 &lt;&lt;line 15
'set rsCars = conn.execute(SQL)
%&gt;
</font id=code></pre id=code>

it sometimes happens on another page where the SQL is
<pre id=code><font face=courier size=2 id=code>SQL = "SELECT * FROM cars WHERE car_new=False ORDER BY car_star ASC, car_sold DESC, id DESC " </font id=code></pre id=code>

Hope someone can help.

Thanks in advance
Wayne

Edited by - wayne1000 on 13 Aug 2004 17:06:25

flush out the SQL to the browser just before executing it and keep trying the page until the error appears..see if the sql is intact or if something is missing...this error usually means the sql is broken....

:: Son, im Thirty.... ::

Could it be a host issue? I'm getting the error on bargain-hosting. I've tried the same site on fasthost and haven't had the error.

If it was an SQL error surly I'd get the error all the time not just occasionally.

regards
Wayne

Edited by - wayne1000 on 16 Aug 2004 14:15:27

no wayne leed is right.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> If it was an SQL error surly I'd get the error all the time not just occasionally.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

afraid not. you'd get it all the time if the db was broken, but it's the sql that's being corrupted somewhere along the lines. either an out of date driver (server side) or something similiar causing the db not to function at 100%. the servers ok most of the time and then every now and again it has to play catch up with itself and you get the error. that's my explanation of it anyway.

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[SQL]|[Access2000]|[ASP/VBScript]|[XP-Pro]

I've tried this code

<pre id=code><font face=courier size=2 id=code>SQL = "select * from cars where id = " & request("id"
response.write SQL
response.Flush()

set rsCars = server.createobject("ADODB.recordset"
'rsCars.open SQL, Conn,1,3
set rsCars = conn.execute(SQL) </font id=code></pre id=code>
and get the following error message

<i>select * from cars where id = 46
Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/carDetails.asp, line 19</i>

<b>set rsCars = conn.execute(SQL)</b> is line 19

regards
Wayne