• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Database Results Error - urgent

The database connection named 'inhouse' is undefined.

I am having real problems with the the following error. I have check the KB and have done the workaround of opening and verifying the db link. This works fine for my local intranet by fails with my dailup ISP


Database Results Error
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


ANy help would appreciated, I have spent nearly a week trying to rectify this


0
dragabyte
Asked:
dragabyte
  • 4
  • 3
1 Solution
 
TTomCommented:
db:

Search your code for the string 'inhouse'.

I am guessing that this is an ASP, probably created using Visual InterDev, and you have created a Data Connection and named it 'inhouse'.  This connection is being used to access your database, but, when it is called on the server, it is not defined properly.

Post up some code from your global.asa and wherever the string appears in your page, and we will troubleshoot it.

(Do you get a line number with the error message?  If so, post that line of code.)

Tom
0
 
dragabyteAuthor Commented:
I am using Frontpage 2000 and the global.asa is a bit to large to post, but I can show what I think is the relevant bit.

Sub Application_OnStart
      '==FrontPage Generated - startspan==
      Dim FrontPage_UrlVars(1)
      '--Project Data Connection
            Application("inhouse_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/idcclient.mdb"
            FrontPage_UrlVars(0) = "inhouse_ConnectionString"
            Application("inhouse_ConnectionTimeout") = 15
            Application("inhouse_CommandTimeout") = 30
            Application("inhouse_CursorLocation") = 3
            Application("inhouse_RuntimeUserName") = ""
            Application("inhouse_RuntimePassword") = ""
      '--
      Application("FrontPage_UrlVars") = FrontPage_UrlVars
      '==FrontPage Generated - endspan==
End Sub

I have a subdirectory called fpdb with the Access2000 db in it. I have been directly opening the db as a file, I have tried a system dsn, a filedsn etc. The progrom works fine on my local NtServer box BUT not on my ISP.

0
 
dragabyteAuthor Commented:
I was using Interdev 6 but switched to FP2000 just to try and get a working connection. There was no error number given
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
TTomCommented:
I suspect this has to do with the switch over from InterDev to FP.  If you created a connection in the InterDev environment, you probably gave it the name "inhouse".  That's why you have all the variables as "inhouse_ConnectionString", etc.  That's what InterDev does when you create a connection and give it a name.

Is the database on the server also in the fpdb subdirectory?  I don't think that's the problem, because, if it was, you would probably get an 80004005 error, not a "non-existent connection".

Can you work directly on the server (i.e., can you create a project in FP or InterDev connected directly to the server)?

Is there anything in the code for your pages like:

conn.open "inhouse"

or

conn.open "DSN=inhouse;"

That would do it.

Hate to say it, but can you post relevant section(s) of the page calling the database?

Tom

0
 
dragabyteAuthor Commented:
I have found the problem and created another.

My ISP doesn't allow subwebs to be application roots!!.

I have to log a job with them to tell them to configure the websub to be an application root. This is where the global.asa should be found. It is a real pain to be tied to the ISP like this.

I don't suppose there is a workaround

Mike
0
 
dragabyteAuthor Commented:
I'll pay the points for your trouble, many thanks
Mike
0
 
TTomCommented:
Mike:

Thanks!  You're most welcome.  I appreciate the points (I often say I'm not here for them, but they do look nice at the top of the page).  

Sorry I couldn't supply a complete, acceptable solution.

Tom
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now