Database Results Wizard Error

C

CEL

Created a database using Access-
Used the Database Interface wizard in FrontPage -

Having problems with database editor - database will not accept
edits...brings up detailed record and accesses the edit page - but when
saving changes the following error occurs:

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

According to what I found out on-line "The reason for this is that the
Timestamp field, which is mandatory in such a database, is a SQL data-type
and must be enclosed in brackets if used as a column name in a database
query."

Did not find the "Timestamp" field within the update.asp page - changed all
column names to include [ and ] - same error still occurs...

?????????????????????
 
C

CEL

using 2002 - have 2003 if that would help correct the problem...

Kathleen Anderson said:
What version of FrontPage?

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



CEL said:
Created a database using Access-
Used the Database Interface wizard in FrontPage -

Having problems with database editor - database will not accept
edits...brings up detailed record and accesses the edit page - but
when saving changes the following error occurs:

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

According to what I found out on-line "The reason for this is that the
Timestamp field, which is mandatory in such a database, is a SQL
data-type and must be enclosed in brackets if used as a column name
in a database query."

Did not find the "Timestamp" field within the update.asp page -
changed all column names to include [ and ] - same error still
occurs...

?????????????????????
 
C

CEL

Kathleen,
Found out that some changes were made using FrontPage 2003 - may causing
changes in the fpclass file... using Access 2000 for database...

Tried copying Frontpage 2002 fpclass files - no help

set the debug to true -

current error is:
Database Results Error
Description: Field 'Results.Region' cannot be a zero-length string.
Number: -2147467259 (0x80004005)
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.

When creating the database interface the "Region" field was originally a
text box on the edit page - changed it to a drop down box - maybe thats the
problem? the current form field properties are:

Name: Region
Initial Value: <%=FP_FieldHTML(fp_rs,"Region")%>
Text Box Validation:
Data Type: No Contstraints
Data Lenght: - Max Length: 255

I do not have this set as a required field -

Varoud fields withing the database are empty - I do not want to require data
to be entered in all fields

I'm don't understand what is going on????? Can you help?????????????





CEL said:
using 2002 - have 2003 if that would help correct the problem...

Kathleen Anderson said:
What version of FrontPage?

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



CEL said:
Created a database using Access-
Used the Database Interface wizard in FrontPage -

Having problems with database editor - database will not accept
edits...brings up detailed record and accesses the edit page - but
when saving changes the following error occurs:

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

According to what I found out on-line "The reason for this is that the
Timestamp field, which is mandatory in such a database, is a SQL
data-type and must be enclosed in brackets if used as a column name
in a database query."

Did not find the "Timestamp" field within the update.asp page -
changed all column names to include [ and ] - same error still
occurs...

?????????????????????
 
C

CEL

Found the problem in the Access Database...
Even though I had the "Required" of each field set to "No" - I had to set
the "Allow Zero Length" - to "Yes" - now everthing works great!


CEL said:
Kathleen,
Found out that some changes were made using FrontPage 2003 - maybe causing
changes in the fpclass file... using Access 2000 for database...

Tried copying Frontpage 2002 fpclass files - no help

set the debug to true -

current error is:
Database Results Error
Description: Field 'Results.Region' cannot be a zero-length string.
Number: -2147467259 (0x80004005)
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.

When creating the database interface the "Region" field was originally a
text box on the edit page - changed it to a drop down box - maybe thats the
problem? the current form field properties are:

Name: Region
Initial Value: <%=FP_FieldHTML(fp_rs,"Region")%>
Text Box Validation:
Data Type: No Contstraints
Data Lenght: - Max Length: 255

I do not have this set as a required field -

Varous fields within the database are empty - I do not want to require data
to be entered in all fields

I'm don't understand what is going on????? Can you help?????????????





CEL said:
using 2002 - have 2003 if that would help correct the problem...

Kathleen Anderson said:
What version of FrontPage?

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



Created a database using Access-
Used the Database Interface wizard in FrontPage -

Having problems with database editor - database will not accept
edits...brings up detailed record and accesses the edit page - but
when saving changes the following error occurs:

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

According to what I found out on-line "The reason for this is that the
Timestamp field, which is mandatory in such a database, is a SQL
data-type and must be enclosed in brackets if used as a column name
in a database query."

Did not find the "Timestamp" field within the update.asp page -
changed all column names to include [ and ] - same error still
occurs...

?????????????????????
 
T

Thomas H. engen

I also have this problem. I use FP and access 2003. Sometimes i shows the
db-result wizard error, and sometimes NOT. In the table the "allow zero
lenght" = Yes.
When I for example delete the IIS-webapplicaton and creat it again it works.
It never gives a good errormessage - Just the "Error in wizard for database
results"+++

I REALLY NEED SOME HELP because i use FP and Access in my web-project and
has to deliver soon

sincerily
Thomas H. Engen
 
T

Thomas H. Engen

"This problem" was really a generel problem with the errormessage "Error in
wizard for database results - please contact....etc" that was discussed in
this discussion.
Sometimes this message "suddenly" appear. From one moment i list the
databaseresult and next time I start IE og push refresh on IE WITHOUT
changing anything in the FP/asp-code. I dont get any good error message (or
where is this this located).

I heard from a developer that he had read about this problem, but didnt
remember where. I thought it was som variable in a file that had to be edited.

Thomas

Kathleen Anderson [MVP - FrontPage] skrev:
 
K

Kathleen Anderson [MVP - FrontPage]

Is this happening on your PC or on your live site?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx


Thomas H. Engen said:
"This problem" was really a generel problem with the errormessage
"Error in wizard for database results - please contact....etc" that
was discussed in this discussion.
Sometimes this message "suddenly" appear. From one moment i list the
databaseresult and next time I start IE og push refresh on IE WITHOUT
changing anything in the FP/asp-code. I dont get any good error
message (or where is this this located).

I heard from a developer that he had read about this problem, but
didnt remember where. I thought it was som variable in a file that
had to be edited.

Thomas

Kathleen Anderson [MVP - FrontPage] skrev:
What is "this problem"? You didn't include any of the previous post
in your message, so I don't know what "this problem" is.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx
 
T

Thomas H. Engen

Both
Thomas

Kathleen Anderson [MVP - FrontPage] skrev:
Is this happening on your PC or on your live site?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx


Thomas H. Engen said:
"This problem" was really a generel problem with the errormessage
"Error in wizard for database results - please contact....etc" that
was discussed in this discussion.
Sometimes this message "suddenly" appear. From one moment i list the
databaseresult and next time I start IE og push refresh on IE WITHOUT
changing anything in the FP/asp-code. I dont get any good error
message (or where is this this located).

I heard from a developer that he had read about this problem, but
didnt remember where. I thought it was som variable in a file that
had to be edited.

Thomas

Kathleen Anderson [MVP - FrontPage] skrev:
What is "this problem"? You didn't include any of the previous post
in your message, so I don't know what "this problem" is.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx


I also have this problem. I use FP and access 2003. Sometimes i
shows
the db-result wizard error, and sometimes NOT. In the table the
"allow zero lenght" = Yes.
When I for example delete the IIS-webapplicaton and creat it again
it works. It never gives a good errormessage - Just the "Error in
wizard
for database results"+++

I REALLY NEED SOME HELP because i use FP and Access in my
web-project and has to deliver soon

sincerily
Thomas H. Engen
 
S

StuartRSV

I had this problem ages ago. the problem was that in my database my table
names and queries had spaces in ie User table I just changed them to
User_table and it works. Hope this helps

Thomas H. Engen said:
Both
Thomas

Kathleen Anderson [MVP - FrontPage] skrev:
Is this happening on your PC or on your live site?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx


Thomas H. Engen said:
"This problem" was really a generel problem with the errormessage
"Error in wizard for database results - please contact....etc" that
was discussed in this discussion.
Sometimes this message "suddenly" appear. From one moment i list the
databaseresult and next time I start IE og push refresh on IE WITHOUT
changing anything in the FP/asp-code. I dont get any good error
message (or where is this this located).

I heard from a developer that he had read about this problem, but
didnt remember where. I thought it was som variable in a file that
had to be edited.

Thomas

Kathleen Anderson [MVP - FrontPage] skrev:

What is "this problem"? You didn't include any of the previous post
in your message, so I don't know what "this problem" is.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx


I also have this problem. I use FP and access 2003. Sometimes i
shows
the db-result wizard error, and sometimes NOT. In the table the
"allow zero lenght" = Yes.
When I for example delete the IIS-webapplicaton and creat it again
it works. It never gives a good errormessage - Just the "Error in
wizard
for database results"+++

I REALLY NEED SOME HELP because i use FP and Access in my
web-project and has to deliver soon

sincerily
Thomas H. Engen
 

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