Database error

[Art]

Creating a very simple page with a SQL query.

I get the error Database Results Error. The operation failed. If this
continues, please contact your server administrator even before I submit a
query.

I vaguely remember a way to turn on more detailed error handling but cant
find my notes.

Also waht would cause this? Other asp pages within this web that were
written before work fine

Thanks

 

[Conrad]

Go to Internet Options --> Advanced and uncheck Show friendly HTTP error
messages.

What is your SQL query?

 

[Trym Bagger]

I suggest you to substitute the line that executes the SQL statement with:
response.write strSQL

(strSQL being your sql statement)

In that way you can check the resulting SQL statement. Copy that statement
and try to run it directly against your database, and tell me the result.

Cheers,

Trym Bagger
www.lacanela.com

 

[Kathleen Anderson [MVP - FrontPage]]

What version of FrontPage? The FP2003 code has changed slightly. 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

If you don't see the _fpclass folder, go to Tools | Web Settings | Advanced
| Options - the checkbox for 'Show documents in hidden directories' needs to
be checked.

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