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 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 |
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
|
DBQ=" & Server.MapPath("data/database.mdb") & "; IMHO this is most professional solution. |
ainsworth14 wrote: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 |