FrontPage Server Extensions for Windows

Author

FP and SQL search

lost in FP and SQL

2004-04-23, 4:35 pm

I am posting this here as well since I suspect this might
have something to do with the server

I think i am going nuts but her goes:

FP 2002 asp page generated with databse results wizard
against a SQL table. If I just list contents of table,
even with where clauses, it all works well.

The minute I add a search form for a field (like client #
equal to), I get an error:

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

Nothing in event logs

Table is created in SQL 2000 running SP3. the asp page is
on a web 2003 machine with IIS 6.

Even a clue on where to look would be appreciated

Thanks