Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 11th, 2004, 08:56 PM
Authorized User
 
Join Date: Apr 2004
Location: , , .
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-

Reply With Quote
  #2 (permalink)  
Old April 12th, 2004, 12:55 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
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
Reply With Quote
  #3 (permalink)  
Old April 12th, 2004, 01:31 PM
Authorized User
 
Join Date: Apr 2004
Location: , , .
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-

Reply With Quote
  #4 (permalink)  
Old April 12th, 2004, 04:44 PM
Authorized User
 
Join Date: Apr 2004
Location: , , .
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-

Reply With Quote
  #5 (permalink)  
Old April 13th, 2004, 11:36 AM
Authorized User
 
Join Date: Apr 2004
Location: , , .
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-

Reply With Quote
  #6 (permalink)  
Old April 13th, 2004, 12:25 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
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
Reply With Quote
  #7 (permalink)  
Old April 13th, 2004, 02:08 PM
Authorized User
 
Join Date: Apr 2004
Location: , , .
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-

Reply With Quote
  #8 (permalink)  
Old April 13th, 2004, 11:17 PM
Authorized User
 
Join Date: Apr 2004
Location: , , .
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-

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 08:56 PM.


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