Database Wizard Results Error Message

J

John

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
 
J

Jim Buyens

This message usually means your query specifies a field
that doesn't exist in the database.

If you hand-typed any or all of the SQL statement, check
the spelling of your field names.

Otherwise, it may be that one of your field names is a
SQL or Access reserved word, such as "date"
or "timestamp". Your options in this case are:

o Open the database in Access, then rename the problem
field(s). Of course, you will need to adjust your
FrontPage pages that use the field as well.
o On page 2 of the DRW, select Custom Query, click Edit,
and put angle brackets around the problem field name.
For example, change timestamp to [timestamp].

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
K

Kathleen Anderson [MVP - FP]

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

John

Jim,

The SQL was generated by DRW. I did not change it.

I am not using any date or time fields. In addition, none of the fields have
date or time in their name.

I am not sure of all of the reserve words. Can you point me to a URL that
lists them?

Since I am not sure which is the problem field, I would not know which field
to enclose in brackets.

John
Jim Buyens said:
This message usually means your query specifies a field
that doesn't exist in the database.

If you hand-typed any or all of the SQL statement, check
the spelling of your field names.

Otherwise, it may be that one of your field names is a
SQL or Access reserved word, such as "date"
or "timestamp". Your options in this case are:

o Open the database in Access, then rename the problem
field(s). Of course, you will need to adjust your
FrontPage pages that use the field as well.
o On page 2 of the DRW, select Custom Query, click Edit,
and put angle brackets around the problem field name.
For example, change timestamp to [timestamp].

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
-----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


.
Click to expand...
Click to expand...
 
J

John

Kathleen,

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

John
 
J

John

Kathleen,

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

John
 
J

JrayK

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!!!
 
A

Alcides Soares

I have exactly the same problem. Last Month, when I intalled FP 2003, all the queries stop working

Since the message was "contact your system administrator", I spent 4 days discussing with my internet provider. Since they didin´t change anything in the system, NOBODY could solve the problem

After four days, I tried again in my office, but using (there) my Front Page in version 2002 (instead 2003 that I installed at my home). I resync all the databases, I recalculate all hiperlinks and, AS A MIRACLE, everything restarded working

My conclusion is that FP changes and updates the files and the hidden _fpclass automaticaly. If you use an old FP version, it updates the files to the OLD version and - MAY BE - everything starts working again. I was reading the current 2003 fpdbrgn1.inc file. There are some RULES that I have never listen. See

' replace any input parameters in query strin
' there need to be at least 5 more characters in the string for there to be input parameters :):[_a-z]::

I have many sites running parameters with just one digit

It seems that MS changed rules and routines - and nobody knows how to help us to use the NEW FP 2003! At this moment, the only solution is to go back to old FP 2002 and try again to solve the 2003 problems
 
J

JrayK

I found a workaround you may want to try.

I went in to the backup of my old FP2002 web and copied all of the
hidden folders out of the old FP2002 and overwrote my production
FP2003 web hidden folders with my old files..

This includes overwriting the folders...

_derived
_fpclass
_vti_cnf
_vti_pvt

Voila, all is working fine now.

Of course this is not a permanent fix but it may get you by until we
find an answer.

I am not sure what file is causing the issue so this shotgun blast
type of approach was the only thing I could think of to get everything
back online. From the looks of things, fpdbrgn1.inc has changed.

Maybe Microsoft has made some changes to protect us from SQL injection
attacks? I dont know....

At least I'm up and running

J
 
S

Stefan B Rusynko

Bad practice and will corrupt your web
The content in all those 4 folders is generated and updated by FP during editing and updating pages
If anything has been changed in FP since your last backup, you will definitely clobber the FP web

Run Tools Recalculate Hyperlinks and FP should repair those files in those folders



| I found a workaround you may want to try.
|
| I went in to the backup of my old FP2002 web and copied all of the
| hidden folders out of the old FP2002 and overwrote my production
| FP2003 web hidden folders with my old files..
|
| This includes overwriting the folders...
|
| _derived
| _fpclass
| _vti_cnf
| _vti_pvt
|
| Voila, all is working fine now.
|
| Of course this is not a permanent fix but it may get you by until we
| find an answer.
|
| I am not sure what file is causing the issue so this shotgun blast
| type of approach was the only thing I could think of to get everything
| back online. From the looks of things, fpdbrgn1.inc has changed.
|
| Maybe Microsoft has made some changes to protect us from SQL injection
| attacks? I dont know....
|
| At least I'm up and running
|
| J
 
P

Pedro Reis

Hi

I had also this problem after upgrading from FP2002 to FP2003, and i
tried this workaround, and it worked for me, thx.
 
R

RichieRich

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
 

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

Similar Threads

Error Adding Record with INSERT INTO 4
Database Results Wizard Error 3
Database Update Issues 2
Database Results Error 1
Frontpage Database Error 1
What is wrong with this 2
Base Article 817029 4
Frontpage 2003 Database Results - Insert parameter - How ? 4

Top