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
%>
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
%>