Print Page | Close Window

connection

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=5690
Printed Date: 29 March 2026 at 6:51pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: connection
Posted By: ainsworth14
Subject: connection
Date Posted: 11 September 2003 at 3:39pm

I know many people ask this but I am having trouble connecting to my remote access db on my hosting server.

I have a site made on my local maching with connections to a local DB, I now want to upload the site to my web host, but am having troubles changing the connection string and making it work.

My site is in: C:\Inetpub\wwwroot\sitename

and my db is in C:\Inetpub\database

my curent connection string is
"Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\database\Record_Webtest.mdb"

all is working great on my local testing server. But how do i know how to connect to the remote location and what should the path look like?? I don tknow much about all this, I have been learning by trial and error, but at this last stage have become slightly stuck.

I have tried many connection strings off the web etc but none have worked, I am  using Dreamweaver MX if that helps.

I know it should be a simple thing to do, but I'm having trouble.

thanks in advance, if i need to give any more info please let me know

mark




Replies:
Posted By: b_bonnett
Date Posted: 11 September 2003 at 4:41pm

Ask your webhost for the physical path to the database folder.

Blair



-------------
Webmaster, http://www.planegallery.net/ - The Plane Gallery
Greetings From Christchurch


Posted By: ainsworth14
Date Posted: 17 September 2003 at 3:23pm

OK fantastic mate,

I now have my path form my webhost.

I have subsituted that path and tried different variations to make it work but I keep getting ODBC errors in dreamweaver when I test the connection. Can anyone please suggest a connection string I can use, as this is my last hurdle on creating my site and is really winding me up!

Also, when I am previewing and amending site design etc, do I have to always connect to my remote DB?

Sorry if these questions sound stupid, but I have been riding on trial and error throught the whole site design process, and have done pretty well up to now........

many thanks
mark



Posted By: michael
Date Posted: 17 September 2003 at 3:49pm
Just put in the path your host gave you the same way as on your local server. Don't worry about the test connection in DW. Just upload it...

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


Posted By: 3BEPb
Date Posted: 17 September 2003 at 10:43pm

Originally posted by ainsworth14 ainsworth14 wrote:

Also, when I am previewing and amending site design etc, do I have to always connect to my remote DB?
This will work for remote SQL server, but not for MS Access. And abouth physical path to your DB folder, I always use the following:

DBQ=" & Server.MapPath("data/database.mdb") & ";

IMHO this is most professional solution.



Posted By: ainsworth14
Date Posted: 18 September 2003 at 3:27pm

you guys are great finally working on live site!! cheers ;-)

3bepb cheers for the string, works great

thanks again
mark




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net