Database Discussion - conn string format for local Access db

Print Page | Close Window

conn string format for local Access db

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4037
Printed Date: 29 March 2026 at 7:40am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: conn string format for local Access db

Posted By: smith_martin
Subject: conn string format for local Access db
Date Posted: 03 July 2003 at 9:26am

current conn string is as follows:

ConnectionString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "db/Registry.adb"

I get a "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." error. Do I have to connect to the server if the script is hosted in the same directory? Basically, what am I doing wrong?

Any help really appreciated.

-------------
--
martin smith
http://students.mwc.edu/~msmit8iu/webdev/index.html

Replies:

Posted By: michael
Date Posted: 03 July 2003 at 9:32am

Option 1:
ConnectionString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourfolder\db\Registry.adb"
Option 2: (make sure it is the right path from the web.)
ConnectionString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("db/Registry.adb")

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker