[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How do I determine the correct data path name?

Posted on 2006-06-23
5
Medium Priority
?
250 Views
Last Modified: 2013-12-24
I am Very new to FrontPage and "inherited" a website to modify.

The website works on the Internet.  I downloaded the files to a new directory I created and named "IMDB"
The global.asa file is in the folder C:\Inetpub\wwwroot
All the other website files are in the folder C:\Inetpub\wwwroot\IMDB

I get the following error message when I try to login (the table and query to determine if the User Name and Password match are in the MS Access file "Demo BE 839.mdb" which is in the folder named "fpdb" at C:\Inetpub\wwwroot\IMDB\fpdb):

"Error Type:
Microsoft JET Database Engine (0x80004005)
'c:\inetpub\wwwroot\fpdb\Demo BE 839.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/IMDB/Login_Validate.asp, line 5"

File Login_Validate.asp reads, in part:
1     <%
2        'Database Connection  --------
3       set CN = Server.CreateObject("ADODB.Connection")
4       CN.ConnectionString = Application("Database1_ConnectionString")
5       CN.Open
6      'Recordset  ------------------
7      set RS = Server.CreateObject("ADODB.Recordset")
8      strSQL = "SELECT Name, Password, UserNumber FROM qryUSysSecurity WHERE Name = '" & Request.Form("UserName") & "';"
9      'Testing ------------
10      'response.write "strSQL = " & strSQL & "<br>"

The global.asa file reads, in part:
5      '--Project Data Connection
6            Application("Database1_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/Demo BE 839.mdb"
7            FrontPage_UrlVars(0) = "Database1_ConnectionString"


Where should the global.asa reside?
How do fix the error?
0
Comment
Question by:bobbat
  • 3
  • 2
5 Comments
 
LVL 20

Expert Comment

by:dopyiii
ID: 17000855
So you said that the .mdb file is in C:\Inetpub\wwwroot\IMDB\fpdb, right?  Well the URL you're passing appears to exclude the IMDB folder in the path (from the error: 'c:\inetpub\wwwroot\fpdb\Demo BE 839.mdb').  In your global.asa, have you tried changing your DBQ=URL= statement to IMDB/fpdb/Demo...?
0
 

Author Comment

by:bobbat
ID: 17019697
Yes, but that did not work so I put all the files back in the root directory.

Now I get "Authentication Error!" when I have "http://localhost/index.htm" in IE address window.

If I use "http://localhost/" in the IE address window the file "C:\Program Files\Belkin Bulldog Plus\WWWRoot\Login.htm" shows on my screen which is a bunch of UPS graphics by Belkin.  I don't know why my login.htm file does not show and it is at "C:\Inetpub\wwwroot\LogIn.htm".

Help!
0
 
LVL 20

Expert Comment

by:dopyiii
ID: 17019914
Well, my comment was simply that your path looked wrong.  If everything is in a relative directory, then that resolves the path issue.  

If your login.htm file would have to be browsed to explicitly if it's not set as the default home page for your site (usually it's index.html, but this is configurable by the web host).  So, if you want to get to login.htm, you'll have to browse to http://localhost/login.htm (I think) to get there.  If you want it to be the default entry page when you go to localhost (or the server address), you'll have to change the name of the file to match what the server is expecting.  Log can login to your IIS server on your local machine to make these kind of changes as necessary.  Make sense?
0
 

Author Comment

by:bobbat
ID: 17020608
No, I'm sorry, I'm just too new this.  I want to run the website locally so I can learn ASP and then edit the site and republish it.  I want to rework the website to make it work locally.  My satellite connection is too slow to edit the Internet site.


What is "Log" and How do I use it to set the default login file, i.e. ". . . make these kind of changes as necessary."
0
 
LVL 20

Accepted Solution

by:
dopyiii earned 2000 total points
ID: 17020677
Well, you can't just run an ASP page without it running on a server (it's an Active Server Page after all).  If you have IIS installed and running, you can run it on your local server (if you have 2000, XP pro, etc.).  The pages are dynamically created by the asp script and then fed to the browser (hence the need for the server).

It might be a good idea to take a quick departure from this project and do a quick ASP tutorial or two.  Once you've got the groundwork, the rest should be easy.  Here are a couple that I'd recommend:

http://msdn.microsoft.com/library/default.asp?URL=/library/en-us/dnasp/html/aspatoz.asp
http://www.w3schools.com/asp/default.asp
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…
Suggested Courses

873 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