ASP.NET Forum

**unclechris** · 02-16-2006, 11:42 PM

I am not a proficient asp programmer, though I (usually get by). But today I have a problem. Any help would be GREATLY appreciated.

I have a simple website linking to an access database. The script works fine on my local machine. And it works fine on my regular host. However, I have uploaded the website to a Windows account with GoDaddy and here is my problem.

I am receiving the following error:

Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/home.asp, line 10

- the WEIRD thing is that if you hit refresh enough times, the page loads fine. Then, at random (it appears), the error resurfaces. No coding changes at all.

Line 10 is in red below:

<% @Language=VBScript %> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<%
set dBaseConn = Server.CreateObject("adodb.connection")
set rs = server.createobject("adodb.recordset")
strConn = "Provider=Microsoft.JET.OLEDB.4.0; Data Source = " & dBasePath & ";"
dBaseConn.open strConn
strSQL = "SELECT * FROM Content where id=10"
rs.open strSQL, dBaseConn
%>

How can it work one minute and then not the next?
Can anyone make any sense of this for me please?

**chrishirst** · 02-17-2006, 07:21 AM

more than likely the hardcoded path is different when on the site.

use server.mappath("path_filename.mdb")

**unclechris** · 02-17-2006, 08:59 AM

No, that's not it. Firstly I used:

<%
dBasePath = Server.MapPath("access_db/filename.mdb")
%>

Secondly, the site works sometimes on the site. Then it comes up with this parameter error other times. I don't get it.

**chrishirst** · 02-17-2006, 09:30 AM

no idea

bit of basic debugging needed. response.write out the values of the variables before they are used so you can see which one is empty.

**unclechris** · 02-17-2006, 09:34 AM

Quote:

Originally Posted by chrishirst

no idea

bit of basic debugging needed. response.write out the values of the variables before they are used so you can see which one is empty.

hmm - you wouldn't be willing to give me a "basic" tutorial here would you?

(I'm not sure what the variables are - told you I'm an amateur!!)

**chrishirst** · 02-17-2006, 09:38 AM

dBaseConn & strConn are the ones to look at

**unclechris** · 10:11 AM

Quote:

Originally Posted by chrishirst

dBaseConn & strConn are the ones to look at

OK - strConn returns:

SELECT * FROM Content where id=10

and dBaseConn returns:

Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=d:\hosting\domain_name\access_db\file_name. mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

Microsoft JET Database Engineerror '80040e10'
No value given for one or more required parameters. /home.asp, line 12

Does that mean anything to you?

Something I've just noticed by accident. One of my scripts never pulls the error. The only difference seems to be that I don't use the WHERE statement in the strConn. So I went and removed the WHERE statement in the first script, and no error either. The dBaseConn was exactly the same.

So, what the heck is wrong with "SELECT * FROM Content where id=10"? If I'm even on the right track...

**unclechris** · 02-17-2006, 04:30 PM

OK, it seems the problem was actually that 'id' was case sensitive. In the database it was 'ID'. Changing the SQL statement to

SELECT * FROM Content where ID=10

fixed the whole thing. Shame on me for writing sloppy case insensitive code.