|
| |
|
|
leanneB
Posts: 10
Joined: 11/26/2003
From: Melbourne, Australia
Status: offline
 |
Database Results Error - database connection undefined - 11/26/2003 18:53:06
Hi, I've just started using the database features of FrontPage and have come across a problem that the help doesn't seem to give me any ways to fix.
The problem is i have made a database connection to a previously made Access mdb file. I have then added a database results section to my page. For some reason when i test this page in my browser i get the following message in the yellow box:
Database Results Error
The database connection named 'DocumentRegister' 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
I think i've checked all these things, can anyone tell me what i might have done wrong?
|
|
|
|
paulie
Posts: 558
Status: offline
|
RE: Database Results Error - database connection undefined - 11/26/2003 19:08:44
leanneB,
Welcome to Outfront! I've learned more here from a few searches on topics in the discussion forums than I did in three entire days of classroom training specific to FrontPage.
From the toolbar in FrontPage, check under Tools/Web Settings/Databases, and see if your "DocumentRegister" database is listed. If so, it should have a green check mark.
It's been awhile since I used the DRW for anything as I have graduated to hand coding datbase connections (which is actually much easier once you get the hang of it - see Spooky's ASP references under the Tutorials)
so I'm shooting somewhat from memory. But basically FrontPage has to "know about" your mdb file so it can update the global.asa behind the scenes. The Tools/Web Settings area is where you configure that.
Hope that helps,
Paul
| |
|
|
|
leanneB
Posts: 10
Joined: 11/26/2003
From: Melbourne, Australia
Status: offline
|
RE: Database Results Error - database connection undefined - 11/26/2003 19:17:13
Thanks Paul.
I'd already checked that and the database connection is there with a green tick. So you say hand coding the connections is easier, maybe i should try that. Looks like i'll have to check the tutorials out.
| |
|
|
|
paulie
Posts: 558
Status: offline
|
RE: Database Results Error - database connection undefined - 11/26/2003 19:42:16
That is a good goal, but in the meantime we should be able to get you going with your current setup. What is the "infrastructure" you're dealing with? (e.g., is the .mdb on a host's server, a test server on a network, your own local machine, etc) Can you open the Access file from your workstation? That should rule out some permissions issues...
| |
|
|
|
leanneB
Posts: 10
Joined: 11/26/2003
From: Melbourne, Australia
Status: offline
|
RE: Database Results Error - database connection undefined - 11/26/2003 21:20:28
the mdb file is on my local machine, and i can open it from my workstation.
| |
|
|
|
leanneB
Posts: 10
Joined: 11/26/2003
From: Melbourne, Australia
Status: offline
|
RE: Database Results Error - database connection undefined - 11/26/2003 23:18:23
Yes i do have a global.asa file. What do you mean by opening the DRW page?
I moved the .asp file into the same directory as the global.asa file and now i get this:
Error Type:
Active Server Pages, ASP 0126 (0x80004005)
The include file '../_fpclass/fpdblib.inc' was not found.
/pgtintranetproto/ePBHC.asp, line 92
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Page:
GET /pgtintranetproto/ePBHC.asp
Time:
Thursday, 27 November 2003, 3:09:45 PM
I think i remember seeing someone else on here have a problem with an include file... i might have to check that out.
Thanks for the help Spooky, if i can't get this fixed soon i might have to go read your tutorials on how to write the code myself.
| |
|
|
|
leanneB
Posts: 10
Joined: 11/26/2003
From: Melbourne, Australia
Status: offline
|
RE: Database Results Error - database connection undefined - 11/30/2003 18:59:57
Done all of that. Still not working
| |
|
|
|
BeTheBall
Posts: 6354
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Results Error - database connection undefined - 11/30/2003 22:20:17
Generally, that error means the web or subweb has not been marked as an application. This is done via IIS. In some cases you can do this yourself by opening the web live and importing a small database into the fpdb folder for your web. If that doesn't work, contact your host.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
leanneB
Posts: 10
Joined: 11/26/2003
From: Melbourne, Australia
Status: offline
|
RE: Database Results Error - database connection undefined - 11/30/2003 23:58:59
Thanks Spooky, that file really helped, it told me that my web isn't marked as an application root. So how do i do this through the IIS?
| |
|
|
|
leanneB
Posts: 10
Joined: 11/26/2003
From: Melbourne, Australia
Status: offline
|
RE: Database Results Error - database connection undefined - 12/2/2003 0:19:13
Thanks for all the help, i managed to get it working by writing my own asp code instead. But i'm gonna go back and see whether this can fix it, as i've already got another problem with using asp. But i'll save that for a new topic.
| |
|
|
|
R Clark
Posts: 161
From: USA
Status: offline
|
RE: Database Results Error - database connection undefined - 12/19/2003 12:49:18
FWIW,
everytime I had this issue, I created a new folder, converted it to a web, dumped all the files from my subweb (subweb where pages having issues are) into this new folder and everything worked. I'm not sure what this is doing because in my scenario's, I've tried all the fixes above with no help. My subweb (and root) could run scripts, my connection verified, sometimes just doing the 'verify hyperlinks' has been suggested but none worked except to transfer all the contents of the subweb to a new folder.
for example, my subweb with db pages that aren't working for the reasons you mentioned is named...
'products'
I create new folder 'products1' and convert it to a web folder, dump all files/folder (even hidden ones) from 'products' into 'products1' (pages now work at this point but I want to eventually get back to a folder named 'products' soooo..) delete corrupt 'products' folder, create new folder named 'products' and convert to web folder, dump all files/folders (even hidden ones) from 'products1' into new 'products' folder, delete 'products1' folder and I'm back to where I started with the same subweb (folder) name except that I don't get the 'connection undefined' error any more and I get my db results.
I know this may be crude but it's quick and it has fixed this problem for me every time without having to recreate pages or rewrite code.
FWIW
Randy
| |
|
|
|
Aelaron
Posts: 223
Joined: 6/8/2004
Status: offline
|
RE: Database Results Error - database connection undefined - 6/8/2004 12:46:56
HELP! I have this issue and been working with my server admin to no avail.
Also, when I try the fpselect.asa file it says that the file fired and then I get this error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'Mid'
/fpselect.asp, line 41
Any help would be appreciated.
Thanks!
JB
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 
