|
| |
|
|
kmsd4
Posts: 16
Joined: 2/21/2002
From: Schofield WI USA
Status: offline
 |
database connection named is undefined - 2/3/2003 21:27:26
I recently uploaded my site to a server and am receiving this error:
Database Results Error
The database connection named ' swmu1' 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 have verified the connections and they are working properly. The global.asp is in the root directory and the paths in the global.asp are correct.
I have also tried creating new result pages and they don' t work either.
Can anyone please help?
|
|
|
|
Richard Dudley
Posts: 668
Joined: 8/22/2002
From: Butler, PA
Status: offline
|
RE: database connection named is undefined - 2/3/2003 21:47:27
It almost certainly has to be the DB connections on your server. If you can, try looking at them on a machine other than the one you built your site on.
_____________________________
I need to change my avatar--the puppy is full grown now!
| |
|
|
|
kmsd4
Posts: 16
Joined: 2/21/2002
From: Schofield WI USA
Status: offline
|
RE: database connection named is undefined - 2/4/2003 7:04:33
I' m on a Microsoft-IIS/5.0 on Windows 2000. I have verified the connection on the web, I tried everything, re-building the asp pages, deleting the web connections and the databases and re-importing them. Nothing seems to work.
I' ve called my ISP and they don' t seem to know either
http://www.vierbicher.com/swmu/results.asp
Any suggestions?
| |
|
|
|
kmsd4
Posts: 16
Joined: 2/21/2002
From: Schofield WI USA
Status: offline
|
RE: database connection named is undefined - 2/4/2003 7:05:56
Also, this is weird when create a sub-web the connenctions in the sub web work fine. More confusing . . . .
| |
|
|
|
kmsd4
Posts: 16
Joined: 2/21/2002
From: Schofield WI USA
Status: offline
|
RE: database connection named is undefined - 2/4/2003 16:53:42
thanks spooky for your help
yes, I am able to verify the connections, on different pc' s, live on the web and the are all working with the green check mark
I will ask my ISP if our web is set up as an application root. Will keep you advised.
It seems like many Front Page users are experiencing this problem.
| |
|
|
|
BigD
Posts: 116
Joined: 12/27/2002
From: Colorado Springs, CO
Status: offline
|
RE: database connection named is undefined - 2/4/2003 20:14:05
Looking at your original post. You say your global.asp file is OK. Your global should be global.asa. Check it out, might be the problem.
< Message edited by BigD -- 2/4/2003 8:14 PM >
_____________________________
" You Never Know What You' re Going To Find!"
| |
|
|
|
kmsd4
Posts: 16
Joined: 2/21/2002
From: Schofield WI USA
Status: offline
|
RE: database connection named is undefined - 2/6/2003 17:24:48
yes, I can verify the connection live, I can make a new page that connects just fine - but when I make a result page I keep getting the same error
The database connection named ' project' 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
?????
| |
|
|
|
kmsd4
Posts: 16
Joined: 2/21/2002
From: Schofield WI USA
Status: offline
|
RE: database connection named is undefined - 2/6/2003 18:29:07
Just off the phone with the ISP once again. Between the both of us we have tried everything. The ISP has made our root directory an application web and no database connections will work within the root directory. The only way a database connection will work is to create a sub directory.
Does anyone have a Microsoft contact that would know anything about this? The ISP suggested me contacting a Microsoft engineer. This has to be a Microsoft thing.
I have a feeling this type of thing happens quite often so many Front pagers.
very weird
| |
|
|
|
kmsd4
Posts: 16
Joined: 2/21/2002
From: Schofield WI USA
Status: offline
|
RE: database connection named is undefined - 2/7/2003 7:34:58
If I make a new page it connects to the database, but it does not display the results.
I' ve also used Microsoft' s fpselect.asp to check the connection. The connection fires, except when I enter a table to display, then I receive the error that the web is not an application root.
I' ve visited newsgroups also and it seems like many users are having the same problem. I have not read a resolution as of yet.
| |
|
|
|
kmsd4
Posts: 16
Joined: 2/21/2002
From: Schofield WI USA
Status: offline
|
RE: database connection named is undefined - 2/7/2003 20:02:45
I would be honored if you would give it an expert look
here is the link http://www.vierbicher.com/
this page is in the root directory http://www.vierbicher.com/projectbid/results_page.asp
this is in the sub web (the only way a database connection will work)
http://www.vierbicher.com/project/results_page.asp
Do you think this has anything to do with virus protection running in the background? I' ve read in the Microsoft Newsgroups something about having to disable script blocking. I' ve tried that but to no avail.
Thanks Spooky, I look forward to your expert view on the situation.
| |
|
|
|
Nathan Goulette
Posts: 274
Joined: 1/12/2003
From: Phoenix, AZ
Status: offline
|
RE: database connection named is undefined - 4/27/2006 11:29:28
Was there ever a resolution to this? I am having the SAME EXACT issue.
I have control of the server and the site IS marked as an application.
I have the same site oringally as a VIR DIR under some other sites and that works fine. I also have a root level site that points to the same exact folder as the VIR DIR does and it is not working. I am getting the same 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
This was working yesterday without issue but has now all of the sudden, over night become a problem.
Thanks.
Nate
| |
|
|
|
Nathan Goulette
Posts: 274
Joined: 1/12/2003
From: Phoenix, AZ
Status: offline
|
RE: database connection named is undefined - 4/27/2006 11:38:27
Ha. Figures that as soon as I post, I fixed it.
I know what I did to fix it but not entirely sure as to why this was the fix.
Although it is already marked as an application root, the Applicaiton Protection that was set was the 'Medium (Pooled)'.
I changed it to 'Low (IIS Process)' and the error went away and the site works as intended.
The only think that I can think of is that the App Pool is jacked. I think that an IISRESET would resolve it but can't really do that on a PROD server without resetting all the connections.
Maybe I will reset them off hours and put the Application Protection back to 'Medium (Pooled)' and see what happens.
Thanks
Nate
| |
|
|
|
sisal
Posts: 1
Joined: 7/1/2008
Status: offline
|
RE: database connection named is undefined - 7/1/2008 21:04:22
Does this help?
http://support.microsoft.com/kb/926939
Error message when you request an ASP page that connects to an Access database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
View products that this article applies to.
Article ID : 926939
Last Review : April 21, 2008
Revision : 3.2
Important This article contains information that shows you how to help lower security settings or how to turn off security features on a computer. You can make these changes to work around a specific problem. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this workaround in your particular environment. If you implement this workaround, take any appropriate additional steps to help protect the computer.
SYMPTOMS
Consider the following scenario. On a Web server that is running Microsoft Internet Information Services (IIS) 7.0, you host an active server page (ASP) that connects to a database. The ASP page data provider is the Microsoft.Jet.OLEDB.4.0 data provider. The ASP page data source is a Microsoft Access database (.mdb) file. In this scenario, you may receive the following error message when you request the ASP page:
Microsoft JET Database Engine error '80004005'
Unspecified error
Note You will encounter a similar error message when you use both of the following:
• A Microsoft Access database in the Access 2007 file format (.accdb)
• The Microsoft.ACE.OLEDB.12.0 data provider
Back to the top
CAUSE
This problem may occur if IIS 7.0 is configured to load the current user profile for an application pool identity. This may cause compatibility issues with legacy ASP-based applications and ADO-based applications because the current user may not have sufficient permissions to write to the temporary directory.
Back to the top
RESOLUTION
To resolve this problem, you must add the correct access control entries to the temporary directory for the process identity. To do this, follow these steps.
Note By default, the process identity is NetworkService, and the temporary directory is %windir%\ServiceProfiles\NetworkService\AppData\Local\Temp.
1. Click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.
2. When you are prompted for an administrator password or for a confirmation, type the password or click Continue.
3. Type the following command, and then press ENTER:
icacls %windir%\serviceprofiles\networkservice\AppData\Local\Temp /grant Users:(CI)(S,WD,AD,X)
Note This command enables every user to create files and directories in the temporary directory.
4. Type the following command, and then press ENTER:
icacls %windir%\serviceprofiles\networkservice\AppData\Local\Temp /grant "CREATOR OWNER":(OI)(CI)(IO)(F)
Note The user who creates a file or a directory in the temporary directory is the CREATOR OWNER. The CREATOR OWNER access control entry grants a user complete control over the file or the directory. Other users cannot access these files and directories because they are not the CREATOR OWNER.
Back to the top
WORKAROUND
To resolve this problem, use the method that is described in the "Resolution" section. However, if you do not want to add access control entries to the temporary directory for the process identity, you can work around the problem by disabling the loadUserProfile property for the application pool. When this property is disabled, IIS 7.0 does not load the current user profile for the application pool.
Important If you disable this property, a security risk may be created. Make sure that you understand and evaluate the risks before you implement this workaround.
To disable the loadUserProfile property for the application pool, modify the ApplicationHost.config file. The following example demonstrates how to do this.
| |
|
|
|
kimboecu1
Posts: 30
Joined: 8/15/2004
Status: offline
|
RE: database connection named is undefined - 7/16/2008 10:39:17
As an fyi to everyone. I had the exact same issue and my web host simply reset the application pool then reset IIS and the problem went away. My concern is that other forums have indicated that using Expression Web could possibly be the culprit here. I didn't start having this issue until I opened the web in Expression Web and modified one of the DRW areas. I'll keep everyone posted.
| |
|
|
|
kimboecu1
Posts: 30
Joined: 8/15/2004
Status: offline
|
RE: database connection named is undefined - 7/17/2008 19:01:02
fyi to everyone. my problem came back and niether my web host or anyone else has any solutions. i do know that if i simply open and save the global.asa file, all is back to well... for a few minutes, that is. then, it all gets hosed again.
| |
|
 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 
ky 