Database Wizard Results Error Message

I am using Access 2000, FrontPage 2000 and IIS V5.0 to publish my Web Site
on a local computer.

I created an Access Data Base and used the Database Results Wizard to
display data.

If I use the database as the data source in the Wizard, it runs fine.

I used the Database Results Wizard to specify selection criteria and from a
search form.

After I publish the site, I keep getting the following message:

Database Results Wizard Error
Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

MS Article 817029 does NOT exist.

Any suggestions?

John

Kathleen
Wed Dec 24 14:41:10 CST 2003

John:
How was this database created? In a FrontPage web or with Access? Which
version?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


John <xxxjohnzzz@patmedia.net> wrote:
> I am using Access 2000, FrontPage 2000 and IIS V5.0 to publish my Web
> Site on a local computer.
>
> I created an Access Data Base and used the Database Results Wizard to
> display data.
>
> If I use the database as the data source in the Wizard, it runs fine.
>
> I used the Database Results Wizard to specify selection criteria and
> from a search form.
>
> After I publish the site, I keep getting the following message:
>
> Database Results Wizard Error
> Your page contains a query with user input parameters that could not
> be resolved.
> This could happen if your DatabaseRegionStart webbot has an empty or
> missing s-columnnames or s-columntypes attributes.
> You may need to read Microsoft Knowledge Base Article 817029.
>
> MS Article 817029 does NOT exist.
>
> Any suggestions?
>
> John

John
Fri Dec 26 09:15:07 CST 2003

Kathleen,

The database was created with Access 2003 and then imported into FrontPage
2003. It is in 2002 Access format.

John


"Kathleen Anderson [MVP - FP]" <spiderwebwoman@mvps.org> wrote in message
news:O82ZU5lyDHA.2316@TK2MSFTNGP10.phx.gbl...
> John:
> How was this database created? In a FrontPage web or with Access? Which
> version?
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> John <xxxjohnzzz@patmedia.net> wrote:
> > I am using Access 2000, FrontPage 2000 and IIS V5.0 to publish my Web
> > Site on a local computer.
> >
> > I created an Access Data Base and used the Database Results Wizard to
> > display data.
> >
> > If I use the database as the data source in the Wizard, it runs fine.
> >
> > I used the Database Results Wizard to specify selection criteria and
> > from a search form.
> >
> > After I publish the site, I keep getting the following message:
> >
> > Database Results Wizard Error
> > Your page contains a query with user input parameters that could not
> > be resolved.
> > This could happen if your DatabaseRegionStart webbot has an empty or
> > missing s-columnnames or s-columntypes attributes.
> > You may need to read Microsoft Knowledge Base Article 817029.
> >
> > MS Article 817029 does NOT exist.
> >
> > Any suggestions?
> >
> > John
>
>

Kathleen
Fri Dec 26 09:37:40 CST 2003

John:
See if this article helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;289317

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

John <xxxjohnzzz@patmedia.net> wrote:
> Kathleen,
>
> The database was created with Access 2003 and then imported into
> FrontPage 2003. It is in 2002 Access format.
>
> John
>
>
> "Kathleen Anderson [MVP - FP]" <spiderwebwoman@mvps.org> wrote in
> message news:O82ZU5lyDHA.2316@TK2MSFTNGP10.phx.gbl...
>> John:
>> How was this database created? In a FrontPage web or with Access?
>> Which version?
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> John <xxxjohnzzz@patmedia.net> wrote:
>>> I am using Access 2000, FrontPage 2000 and IIS V5.0 to publish my
>>> Web Site on a local computer.
>>>
>>> I created an Access Data Base and used the Database Results Wizard
>>> to display data.
>>>
>>> If I use the database as the data source in the Wizard, it runs
>>> fine.
>>>
>>> I used the Database Results Wizard to specify selection criteria and
>>> from a search form.
>>>
>>> After I publish the site, I keep getting the following message:
>>>
>>> Database Results Wizard Error
>>> Your page contains a query with user input parameters that could not
>>> be resolved.
>>> This could happen if your DatabaseRegionStart webbot has an empty or
>>> missing s-columnnames or s-columntypes attributes.
>>> You may need to read Microsoft Knowledge Base Article 817029.
>>>
>>> MS Article 817029 does NOT exist.
>>>
>>> Any suggestions?
>>>
>>> John

steve
Fri Dec 26 16:31:53 CST 2003

In learning to use the DWR myself, this problem went away
when I set "default" values for the criteria in the DWR
process. hth

steve
>-----Original Message-----
>I am using Access 2000, FrontPage 2000 and IIS V5.0 to
publish my Web Site
>on a local computer.
>
>I created an Access Data Base and used the Database
Results Wizard to
>display data.
>
>If I use the database as the data source in the Wizard,
it runs fine.
>
>I used the Database Results Wizard to specify selection
criteria and from a
>search form.
>
>After I publish the site, I keep getting the following
message:
>
>Database Results Wizard Error
>Your page contains a query with user input parameters
that could not be
>resolved.
>This could happen if your DatabaseRegionStart webbot has
an empty or missing
>s-columnnames or s-columntypes attributes.
>You may need to read Microsoft Knowledge Base Article
817029.
>
>MS Article 817029 does NOT exist.
>
>Any suggestions?
>
>John
>
>
>.
>

John
Fri Dec 26 19:45:50 CST 2003

Kathleen,

I saw that article. I am using FP 2003 and do not see
myConnection_interface, anywhere.

John

"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
message news:OyYm0Y8yDHA.1524@TK2MSFTNGP10.phx.gbl...
> John:
> See if this article helps:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;289317
>
> --
>
> ~ Kathleen Anderson
> Microsoft FrontPage MVP
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
> John <xxxjohnzzz@patmedia.net> wrote:
> > Kathleen,
> >
> > The database was created with Access 2003 and then imported into
> > FrontPage 2003. It is in 2002 Access format.
> >
> > John
> >
> >
> > "Kathleen Anderson [MVP - FP]" <spiderwebwoman@mvps.org> wrote in
> > message news:O82ZU5lyDHA.2316@TK2MSFTNGP10.phx.gbl...
> >> John:
> >> How was this database created? In a FrontPage web or with Access?
> >> Which version?
> >>
> >> --
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> John <xxxjohnzzz@patmedia.net> wrote:
> >>> I am using Access 2000, FrontPage 2000 and IIS V5.0 to publish my
> >>> Web Site on a local computer.
> >>>
> >>> I created an Access Data Base and used the Database Results Wizard
> >>> to display data.
> >>>
> >>> If I use the database as the data source in the Wizard, it runs
> >>> fine.
> >>>
> >>> I used the Database Results Wizard to specify selection criteria and
> >>> from a search form.
> >>>
> >>> After I publish the site, I keep getting the following message:
> >>>
> >>> Database Results Wizard Error
> >>> Your page contains a query with user input parameters that could not
> >>> be resolved.
> >>> This could happen if your DatabaseRegionStart webbot has an empty or
> >>> missing s-columnnames or s-columntypes attributes.
> >>> You may need to read Microsoft Knowledge Base Article 817029.
> >>>
> >>> MS Article 817029 does NOT exist.
> >>>
> >>> Any suggestions?
> >>>
> >>> John
>

Kathleen
Mon Dec 29 08:41:53 CST 2003

Can you post your SQL?

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


John <xxxjohnzzz@patmedia.net> wrote:
> Kathleen,
>
> I saw that article. I am using FP 2003 and do not see
> myConnection_interface, anywhere.
>
> John
>
> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote
> in message news:OyYm0Y8yDHA.1524@TK2MSFTNGP10.phx.gbl...
>> John:
>> See if this article helps:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;289317
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft FrontPage MVP
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>> John <xxxjohnzzz@patmedia.net> wrote:
>>> Kathleen,
>>>
>>> The database was created with Access 2003 and then imported into
>>> FrontPage 2003. It is in 2002 Access format.
>>>
>>> John
>>>
>>>
>>> "Kathleen Anderson [MVP - FP]" <spiderwebwoman@mvps.org> wrote in
>>> message news:O82ZU5lyDHA.2316@TK2MSFTNGP10.phx.gbl...
>>>> John:
>>>> How was this database created? In a FrontPage web or with Access?
>>>> Which version?
>>>>
>>>> --
>>>> ~ Kathleen Anderson
>>>> Microsoft MVP - FrontPage
>>>> Spider Web Woman Designs
>>>> http://www.spiderwebwoman.com/resources/
>>>>
>>>>
>>>> John <xxxjohnzzz@patmedia.net> wrote:
>>>>> I am using Access 2000, FrontPage 2000 and IIS V5.0 to publish my
>>>>> Web Site on a local computer.
>>>>>
>>>>> I created an Access Data Base and used the Database Results Wizard
>>>>> to display data.
>>>>>
>>>>> If I use the database as the data source in the Wizard, it runs
>>>>> fine.
>>>>>
>>>>> I used the Database Results Wizard to specify selection criteria
>>>>> and from a search form.
>>>>>
>>>>> After I publish the site, I keep getting the following message:
>>>>>
>>>>> Database Results Wizard Error
>>>>> Your page contains a query with user input parameters that could
>>>>> not be resolved.
>>>>> This could happen if your DatabaseRegionStart webbot has an empty
>>>>> or missing s-columnnames or s-columntypes attributes.
>>>>> You may need to read Microsoft Knowledge Base Article 817029.
>>>>>
>>>>> MS Article 817029 does NOT exist.
>>>>>
>>>>> Any suggestions?
>>>>>
>>>>> John

your_pcgeek
Mon Dec 29 14:44:06 CST 2003

I am receiveing the exact same error.

I upgraded my frontpage from FP2002 to FP2003 yesterday and all hell
has broken loose.

I receive that error only on Database Results Wizard pages that
receive parameters in to the SQL statement.... I receive the error if
I pass params in the querystring and also if I post from a form.

All of my other Database Results Wizard page function fine....Just the
ones that accept parameters are failing.

Everything worked perfectly yesterday. The only thing I changed was I
installed FP2003. I did not change the asp pages in any way shape or
form.

HELP!!!

RichieRich
Fri Feb 06 10:12:37 CST 2004

Where is the Timestamp entry, as referenced in KB289317? I have all hidden showing and cannot see that anywhere in FP 2003 web
created using the DB wizard?
error:

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for all form fields that are used in the query.

thanks



"John" <xxxjohnzzz@patmedia.net> wrote in message news:eQKorsBzDHA.2780@TK2MSFTNGP09.phx.gbl...
> Kathleen,
>
> I saw that article. I am using FP 2003 and do not see
> myConnection_interface, anywhere.
>
> John
>
> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
> message news:OyYm0Y8yDHA.1524@TK2MSFTNGP10.phx.gbl...
> > John:
> > See if this article helps:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;289317
> >
> > --
> >
> > ~ Kathleen Anderson
> > Microsoft FrontPage MVP
> > Spider Web Woman Designs
> > http://www.spiderwebwoman.com/resources/
> >
> > John <xxxjohnzzz@patmedia.net> wrote:
> > > Kathleen,
> > >
> > > The database was created with Access 2003 and then imported into
> > > FrontPage 2003. It is in 2002 Access format.
> > >
> > > John
> > >
> > >
> > > "Kathleen Anderson [MVP - FP]" <spiderwebwoman@mvps.org> wrote in
> > > message news:O82ZU5lyDHA.2316@TK2MSFTNGP10.phx.gbl...
> > >> John:
> > >> How was this database created? In a FrontPage web or with Access?
> > >> Which version?
> > >>
> > >> --
> > >> ~ Kathleen Anderson
> > >> Microsoft MVP - FrontPage
> > >> Spider Web Woman Designs
> > >> http://www.spiderwebwoman.com/resources/
> > >>
> > >>
> > >> John <xxxjohnzzz@patmedia.net> wrote:
> > >>> I am using Access 2000, FrontPage 2000 and IIS V5.0 to publish my
> > >>> Web Site on a local computer.
> > >>>
> > >>> I created an Access Data Base and used the Database Results Wizard
> > >>> to display data.
> > >>>
> > >>> If I use the database as the data source in the Wizard, it runs
> > >>> fine.
> > >>>
> > >>> I used the Database Results Wizard to specify selection criteria and
> > >>> from a search form.
> > >>>
> > >>> After I publish the site, I keep getting the following message:
> > >>>
> > >>> Database Results Wizard Error
> > >>> Your page contains a query with user input parameters that could not
> > >>> be resolved.
> > >>> This could happen if your DatabaseRegionStart webbot has an empty or
> > >>> missing s-columnnames or s-columntypes attributes.
> > >>> You may need to read Microsoft Knowledge Base Article 817029.
> > >>>
> > >>> MS Article 817029 does NOT exist.
> > >>>
> > >>> Any suggestions?
> > >>>
> > >>> John
> >
>
>