Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > BOOK: Beginning ASP 3.0
Password Reminder
Register
| FAQ | Members List | Calendar | 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 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
 
 
Thread Tools Search this Thread Display Modes
  #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
 


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
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



All times are GMT -4. The time now is 07:22 PM.


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