Database Results Wizard Error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Doug Speer (DougSpeer_at_discussions.microsoft.com)
Date: 08/05/04 

Date: Wed, 4 Aug 2004 23:09:04 -0700

I received the following error when using the Database Results Wizard
Database Results Wizard Error (with DEBUG set to True):

The database connection named 'BooksByTitle' is undefined.

"This problem can occur if:
* the connection has been removed from the web
* the file 'global.asa' is missing or contains errors
* the root folder does not have Scripting permissions enabled
* the web is not marked as an Application Root"

Regarding the error message:
The connection to the database is present and verified.
The file 'global.asa' is present but I do not know how to detect errors in
the file.
I do not know how to determine the status of the third and fourth bullets in
the error message.

My configuration is FrontPage 2003, Windows 2000, IIS 5.0, Access 97.
The database table has 5 columns and 560 rows. One column is ID autonumber;
the other 4 columns are text.

Upon executing the page the table column are displayed followed by the above
error message.

Please assist.

Thanks. 

-- 
Doug Speer

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: Delphi.net is Beta?
    ... error message come up before you have a chance to do that?) ... I let the wizard build the connection string and after it when it comes to ... I can see the list of tables in the database but if I choose any of them, ... Invalid object name 'SYSINDEXKEYS'. ...
    (borland.public.delphi.non-technical)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: Accessing mdb file via VB code
    ... but then I encountered the error message "Unable to find ... installable ISAM" when a connection to my database was attempted on another ... Dim strConn As String ... By using UserID and Password in the connection string one is telling Jet ...
    (microsoft.public.vb.general.discussion)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)