Wrox Programmer Forums
|
BOOK: Beginning Dreamweaver MX/MX 2004 MX ISBN: 978-0-7645-4404-0; MX 2004 ISBN: 978-0-7645-5524-4
This is the forum to discuss the Wrox book Beginning Dreamweaver MX by Charles E. Brown, Imar Spaanjaars, Todd Marks; ISBN: 9780764544040
Please indicate which version of the book you are using when posting questions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Dreamweaver MX/MX 2004 MX ISBN: 978-0-7645-4404-0; MX 2004 ISBN: 978-0-7645-5524-4 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 October 16th, 2005, 07:04 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

How does your connection string look? Are you using a DSN?

And does your provider have any documentation about using an Access database? Quite often, the ISP provides information about how to use a database in your ASP pages, including sample code for the connection string.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old October 16th, 2005, 08:30 AM
Authorized User
 
Join Date: Aug 2005
Posts: 96
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I will chat with my provider tomorrow about it. I am using a DNS-less connection string. "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\wwwroot\timberdb1.mdb"

TA

Mal
 
Old October 16th, 2005, 08:52 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Instead of this outdated ODBC driver, you're better off using an OleDb connection. Look here for some examples:

http://www.connectionstrings.com/

then expand Access and then OleDb.

Also, instead of hard coding your path, use Server.MapPath. Your local site may have a folder called C:\Inetpub, but your ISP may not. Your site could be located on D;\users\malhyp\WhatEver\SomeFolder\ for example.

Using MapPath, you can dynamically build up the path to the database:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/Databases/db1.mdb") & ";"

This returns the full path for your database called db1.mdb located in the Databases folder in the root of your site.....

HtH,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Login page problem mashour BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 5 November 18th, 2008 05:25 PM
problem in designing login page like orkut nirmalbarsainyan ASP.NET 1.x and 2.0 Application Design 1 April 19th, 2007 05:15 AM
Login page back to original page pablohoney Classic ASP Basics 1 October 3rd, 2006 07:09 PM
LOGIN PAGE (does not link to the next page) [email protected] Classic ASP Databases 7 April 5th, 2006 01:28 PM
Newbie Help. Login to unique login page per user Kainan Classic ASP Professional 10 May 3rd, 2005 07:47 AM





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