FrontPage Server Extensions for Windows - global.asa creates database results error

Author

global.asa creates database results error

John H

2004-02-17, 6:34 pm

Hi all.
I've been having trouble publishing a site from FP to a
server running Windows Server 2003, IIS 6 and FPSE 2002.
Whenever I do so, FP generates some code which is added
to global.asa (convertfromODBC). This code creates
database results errors 'incomplete query clause'. By
manually removing such code, the pages are restored, but
my changes are reversed whenever I republish, recalculate
or edit any part of the site. Even choosing not to
publish global.asa the problem persists. Why does FP do
this, and how can I prevent it from happening?- If it was
left alone, my site would be fine.
Thanks,

John.