Solved

Database Results Error - urgent

Posted on 2000-03-20
7
213 Views
Last Modified: 2013-12-24
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
Comment
Question by:dragabyte
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 9

Expert Comment

by:TTom
ID: 2636474
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
 

Author Comment

by:dragabyte
ID: 2637981
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
 

Author Comment

by:dragabyte
ID: 2637990
I was using Interdev 6 but switched to FP2000 just to try and get a working connection. There was no error number given
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 9

Accepted Solution

by:
TTom earned 200 total points
ID: 2640209
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
 

Author Comment

by:dragabyte
ID: 2642993
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
 

Author Comment

by:dragabyte
ID: 2646742
I'll pay the points for your trouble, many thanks
Mike
0
 
LVL 9

Expert Comment

by:TTom
ID: 2649132
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question