Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 11th, 2004, 08:56 PM
Authorized User
 
Join Date: Apr 2004
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default cannot run ASP scripts

I am having a terrible time finding the answer to the following problem. I have a virtual directory setup over a network share. I can access the pages fine, but when I try to run any ASP scripts that connect to an Access database, I get the following Microsoft JET error:

"Disk or Network error"

I've been trying to figure this out for almost a week without any luck. I can access the page okay, but as soon as I try and run the ASP script (submitting a form for example) I get the above error. I know the scripts work okay because I've tried on other servers running IIS and everything works. So, it has to be a problem with my IIS setup or something that I didn't configure right to run ASP scripts. Can anyone please help. I'm completely at a loss? I don't know what else to try?
Thanks for any help.
-Dman100-

 
Old April 12th, 2004, 12:55 PM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

What's the path to the resource? Is it a mapped drive?

ASP pages run under a different security context then you are when you browse the network. So it's likely that you are experiencing a limitation because of that.

Peter
-------------------------
Work smarter, not harder
 
Old April 12th, 2004, 01:31 PM
Authorized User
 
Join Date: Apr 2004
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Peter,
Thanks for replying to my post. I really appreciate the help.

When I create the virtual directory using the wizard. I browse to the actual path, which is:
\\workstation_name\E_drive\site_name

The wizard then asks for the username and password to gain access to the network resource. No matter what I use IUSR_servername or admin. I get a red stop sign error when the virtual directory is created. I can't access the page and get a restricted access logon failed error now.

I assume this is a permissions error?? I'm guessing though? Any ideas what I'm doing wrong? Thanks a bunch for any help!
-Dman100-

 
Old April 12th, 2004, 04:44 PM
Authorized User
 
Join Date: Apr 2004
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Peter,

Additional information...

I created an identical new user on both the IIS web server and the workstation PC where the share is located.

So, when I created the virtual directory and was prompted for the username and password to gain access to the network resource, I selected the new user account I setup.

I can now access the index page again, but still can't run the ASP scripts? I am back to getting the "disk or network error."

Is this a permissions problem? Do I need to set permissions for the mapped folder containing the site files and DB on the IIS web server? The mapped drive folder has the "everyone" account listed. What do I need to do to run to get the ASP scripts to run?

Thanks for your help.
-Dman100-

 
Old April 13th, 2004, 11:36 AM
Authorized User
 
Join Date: Apr 2004
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I found the following Microsoft article after researching the specific error I was getting.

Can anyone explain the resolution listed in the following Microsoft article:

http://support.microsoft.com/default...b;EN-US;251254

I have read the article several times and have gone into the control panel, opened the system dialog and looked at the system environment variables on my server, which are:

Temp = c:\winnt\temp
TMP = c:\winnt\temp

The Temp folder does exist in windows explorer.

Then I opened the command shell and used the set command to check the system environment, which showed the following for the temp folder:

Temp = c:\docume~1\admini~1\locals~1\temp
TMP = c:\docume~1\admini~1\locals~1\temp

That folder also exists in windows explorer.

So, is there a conflict here? Is the system environment for the temp directory pointing to two different to paths? Is this why I’m getting the error when trying to run ASP scripts connecting to an Access database?

I didn't understand what I needed to do to correct the error as described in the resolution of the Microsoft article. I'm not sure what and how I need to edit to correct the problem.

Can anyone please help.
Thanks,
-D-

 
Old April 13th, 2004, 12:25 PM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

Did you perform all the steps under the resolution section of the article?

I think that trying to get scripts and databases running over a network share is pretty difficult because of permissions problems. I've never done it so all I can recommend is to follow what the MS articles say and make the necessary adjustments to account for this situation being a network issue. Much will be dependent on the user account that IIS is running as.

Peter
-------------------------
Work smarter, not harder
 
Old April 13th, 2004, 02:08 PM
Authorized User
 
Join Date: Apr 2004
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Peter,

That is where I am confused. The steps to resolve the problem listed in the article. How and what do I edit in regards to the environment variables?? What are the steps? The article was as clear as mud to me? I was hoping someone could explain these steps.

Also, I did try to place the site locally onto the server and create the virtual directory. The same problem occurred. So, it doesn't appear to be related to permissions problem over a network share.

Thanks again! I do appreciate your help.
-Dman100-

 
Old April 13th, 2004, 11:17 PM
Authorized User
 
Join Date: Apr 2004
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I finally figured the problem out. It didn't dawn on me until just now that I needed to change the connection string to the path of the network share. Changed the connection string to reflect the network share path and viola...everything works. Thank you again for taking the time to help me. I really appreciate it!
-Dman100-






Similar Threads
Thread Thread Starter Forum Replies Last Post
running asp.net scripts owoade .NET Web Services 3 August 27th, 2007 08:06 PM
HOWTO run WSH scripts from ASP?? fhameed Classic ASP Professional 1 July 2nd, 2006 10:55 AM
I cant run asp scripts majc Classic ASP Basics 4 December 3rd, 2005 06:14 AM
Automating ASP Scripts Ryanvdm Classic ASP Basics 6 September 23rd, 2004 03:43 AM
how two scripts run at a time ? mateenmohd Javascript 8 April 26th, 2004 03:47 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.