Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP 3.0 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
  #1 (permalink)  
Old June 30th, 2004, 03:43 PM
Registered User
 
Join Date: Jun 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Beginning ASP 3.0, Chapter 12 (Connect.asp).

I have tried a variety of database paths with this page, and none of them work. I using a remote server and uploading via Dreamweaver. This message keeps showing up (with some variation, depending on how I write the path):

Microsoft JET Database Engine error '80004005'

'D:\WWWRoot\lastchance.info\www\session\database\M ovie2000.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.

/session/connect.asp, line 25

Can anybody help me? I've looked at every page in the ASP forum, and couldn't find anything that fixed this problem. . .

Thanks!

  #2 (permalink)  
Old July 2nd, 2004, 01:14 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Richard,

Check Server.MapPath() function and use relative path and .mdb file name as its parameter.

_________________________
- Vijay G
Strive for Perfection
  #3 (permalink)  
Old July 5th, 2004, 01:36 AM
Friend of Wrox
Points: 1,288, Level: 14
Points: 1,288, Level: 14 Points: 1,288, Level: 14 Points: 1,288, Level: 14
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2004
Location: Stockholm, Sweden
Posts: 331
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to qazi_nomi
Default

Can u post the code of the page here

Love 4 all
  #4 (permalink)  
Old July 22nd, 2004, 03:01 PM
Registered User
 
Join Date: Jul 2004
Location: Fair Oaks, CA, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am having a similar problem. Although the error code is different, I think it relates to the same issue: the path in the connection string. The book says to save the Movie2000 database file on the C: drive of your LOCAL computer, and that's the path referenced in the code of the Connect.asp example. When run, however, it produces a server error. At no point is the reader instructed to upload the database file to the server, which leads me to wonder whether code that's carried out on the server would have any way of finding a database file on the client machine - ? It seems like the db file should be uploaded to the server, and that the path is wrong - but I'm not sure how to fix it.
  #5 (permalink)  
Old July 24th, 2004, 04:12 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:At no point is the reader instructed to upload the database file to the server, which leads me to wonder whether code that's carried out on the server would have any way of finding a database file on the client machine
I don't have that book with me. But I assume that the book wouldn't have instructed the reader to upload to server, as it would have been written in a view that one would practice all that in a PC where IIS runs.

In your case, if you could upload the file to the server, you can do that. Else you can share your folder that has the mdb file use that in the connectionstring as the path - "\\yoursystem\sharedfoldername\your.mdb".

IMO, one would not prefer have the database file stored in the client, unless he faces problem in making changes to db from a remote system where IIS runs.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 12 - Not redirect or connect with user Alejor BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 January 5th, 2006 06:25 PM
Ch. 12 Connect.asp mcauliff BOOK: Beginning ASP 3.0 2 August 5th, 2005 02:47 PM
Beginning Access VBA Chapter 12 Comet_0891 BOOK: Beginning Access 2003 VBA 0 June 6th, 2005 11:42 PM
Beginning asp 3.0: Chapter 15 karoshi BOOK: Beginning ASP 3.0 1 March 10th, 2005 05:58 PM
Beginning Visual C# Exercises - Chapter 12 seblake C# 1 August 21st, 2004 02:55 PM





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