Solved

Database Results Error - urgent

Posted on 2000-03-20
7
203 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
  • 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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
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 an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…
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…

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now