DRW No value given for one or more required parameters

M

Mark Constant

As I stated in a previous post that got answered I moved a webpage
over to a new server. Originally I was getting an error because I
didn't change the Linked Table Manager in Access. It was pointing to
the old Excel sheet on the old server. I fixed that and ran an update.
I also corrected it so now the includes state #include
virtual="/_fp../" instead of #include file="../_fp/". But whenever I
try to click on one of the ASP pages it says

Database Results Wizard Error
Description: No value given for one or more required parameters.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

It almost looks like a problem with the query I am running now but I
didn't change the querys when I moved over to the new server. I also
checked the global.asa file and that is correct. Is there something
about switching to IIS that would cause this problem? Below is one
that doesn't work. The only one that does work is below that one.

<%
fp_sQry="SELECT * FROM Person_Query ORDER BY Name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=3 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="phonelist_connection"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Name=202&Ext=202&Location=202&"
fp_iDisplayCols=3
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>

<%
fp_sQry="SELECT * FROM Nonperson_Query ORDER BY Name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="phonelist_connection"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Name=202&Ext=202&Location=202&Title=202&Type=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top