Database called from different URL
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4153
Printed Date: 02 April 2026 at 5:07am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Database called from different URL
Posted By: Gemma Fairchild
Subject: Database called from different URL
Date Posted: 09 July 2003 at 4:25am
|
Hi, I'm moving URL's over the next few months, and want to test the forum on the new site. I want to use the current database, but I'm not sure how to change the line in the common.asp files to read the database from a remote site ------------- Gemma from http://www.herpetofauna.co.uk - RAUK |
, can anyone help?Replies:
Posted By: kbannon
Date Posted: 09 July 2003 at 5:01am
|
Not sure how to do this but I suspect that if you could change common.asp on server #2 and gain access to the DB then anyone could do this! Just make a copy of the DB you have at the moment and use that for testing on server #2 ------------- I don't suffer from insanity, I enjoy every minute of it. |
Posted By: ljamal
Date Posted: 09 July 2003 at 8:35am
|
If you are using SQL Server, then you can do this simply by copying the forum pages to your new server. If you are not using SQL Server, then it is not possibnle with Access. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: kbannon
Date Posted: 09 July 2003 at 8:56am
|
I am not an SQL Server user but does that mean anyone the name of the DB can access the DB from another server just by putting the pages up on the net somewhere? ------------- I don't suffer from insanity, I enjoy every minute of it. |
Posted By: thedave
Date Posted: 09 July 2003 at 9:35am
|
you need to know your path of your new server to point to the the database, your new servers paths are probably going to be different to your old ones, depending on what host your using obviously. e.g. path to old db E:\site\forum\admin\database\dbname.mdb path to new db C:\site\root\forum\admin\database\dbname.mdb i can see that youll need to edit the common.asp to point to the path on your new server to the db, so i dont see why you shouldnt be able to use your old database on your new server.. - edit - i read your post wrong sorry i though you just wanted to use your old db, well thats what you have to do, you cant call it from another url with access, you will have to backup your old forum db and upload it to your new server. ------------- ello?! |
Posted By: ljamal
Date Posted: 09 July 2003 at 10:17am
SQL Server databases have a username and password, so you would have to know the username AND password to access the account. For instance, my live web server and development web server, both use the same SQL database. One is located on the east coast of the US and the other is located on the west coast but because I know the username and password for the SQL server, I can access the data from any computer connected to the Internet. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
kbannon wrote:Posted By: Gemma Fairchild
Date Posted: 11 July 2003 at 2:39am
|
Thanks for the replies, I'm running an access database, so copied it all over and everything is working fine, thanks again. ------------- Gemma from http://www.herpetofauna.co.uk - RAUK |