Database Results Wizard Error Works on Local Not on Server

[Dave]

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

This works on my local server when I publish to the server
I get the error above. I'm using Access Database with a
view. The database has been published also. Here is the
Query

SELECT newsLetter.datePublished, "<a href=" & '"..' &
newsLetter.newsletter_link & '">' &
newsLetter.newsletter_display & "</a>"
FROM newsLetter
ORDER BY newsLetter.datePublished;

Why do I get this error and is there anyway to get more
debug information than the message i listed above?

 

[Kathleen Anderson [MVP - FrontPage]]

To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


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

 

[Dave]

Thanks for the tip. It worked. Here is the error I'm
getting
Database Results Wizard Error
Description: Syntax error in query. Incomplete query
clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

The Query works fine in Access itself. It also works on
my local site. The Access database is contained in the web
site. I don't believe that Access software is running on
the server. We are running Microsoft Server 2003 on the
server. What is the MicroSoft Jet Database Engine and
where might I find the proper syntaxs for it?
Your replys to everyone's problems are always very
helpful.
Thanks
Dave

 

[Kathleen Anderson [MVP - FrontPage]]

Please read this thread: http://www.frontpagewebmaster.com/m-175524/tm.htm
and see if any of the suggestions help.

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