DRW displays error

[Trillian]

This is a followup to my previous post that was answered by Jim Buyens...

His solution worked for one of my webs but I have a second web with the
exact same page. I copied the code in once I got it working and on that .asp
page I get:

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

That implies I don't have default values for db fields...I think...but it's
the same db that works fine with the other web.

This second web also access another Access db, so the global.asa has two db
connections. Could this be the problem?

I checked an .asp page that accessess this other db and it works. All other
..asp pages in this web access this second db. Only the one problem page
accesses the db common to my other web.

What does the line below do? (at the bottom of the global.asa) I renamed the
db connections db1 and db2 for simplicity:
<mso:connectionstatus msdt:dt="string">db1=1 db2=1</mso:connectionstatus>

In the other web that works, the line is this:
<mso:connectionstatus msdt:dt="string">db1=1</mso:connectionstatus>


In an older version of the global.asa's there was a line below each
multi-line db connection definition like this:

FrontPage_UrlVars(0) = "db1_ConnectionString"

The global.asa for the web that works (with only one db connection) doesn't
have this line and it works fine. I added it back in to the other web and it
made no difference, still got the error.

 

[Thomas A. Rowe]

You must create the connection via the Tools | Web / Site Settings | Database.

The databases need to be in the fpdb folder in the root web, as well as the pages needing access to
the database.

Or

you have to have one set of page and its database in a subweb/subsite, and the database can not be
shared with pages outside of the subweb.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Jim Buyens]

Try deleting and recreating the database connection to the problem database,
then rerunning the DRW.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

 

[Trillian]

I did that, it didn't appear to help, although I think my client may be
having server problems as I couldn't access other pages...and couldn't
refresh, now it just gives a page not found error.

A curious thing, though, on the web page that was working in the other web,
when I just brought that up I now see:

Database Results Error
Description: Syntax error in query expression

'(('00;wtbst=00' = '00') or ([ID] = 00;wtbst=00)) AND (('00' = '00') or
([StateOrProvince] = '00'))'.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

Once I select a value from either dropdown the error goes away and the page
works fine.

This is the final string I worked on from the one suggested (first post of
earlier today):

(('::wtb::' = '00') or ([ID] = ::wtb:) AND (('::wtbst::' = '00') or
([StateOrProvince] = '::wtbst::'))

Where wtb is the name of dropdown 1, the field that matches is ID
and wtbst is the name of dropdown 2, the field that matches is StateOrProvince

ID actually references another table w/in the db where it gets its final
numeric value, but if it's not selected it's a text field '00'.

There may be strange things going on at the client...so I can't really tell,
but if the page worked before, why would it give an error now?