Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Database called from different URL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Database called from different URL
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Gemma Fairchild View Drop Down
Newbie
Newbie
Avatar

Joined: 19 June 2003
Location: United Kingdom
Status: Offline
Points: 32 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gemma Fairchild Quote  Post ReplyReply Direct Link To This Post Topic: Database called from different URL
    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 , can anyone help?
Back to Top
kbannon View Drop Down
Groupie
Groupie


Joined: 03 October 2002
Location: Ireland
Status: Offline
Points: 115 		Post Options Post Options   Thanks (0) Thanks(0)   Quote kbannon Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post 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

L. Jamal Inc : Web/ Print Design and ASP Programming
Back to Top
kbannon View Drop Down
Groupie
Groupie


Joined: 03 October 2002
Location: Ireland
Status: Offline
Points: 115 		Post Options Post Options   Thanks (0) Thanks(0)   Quote kbannon Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
thedave View Drop Down
Groupie
Groupie
Avatar

Joined: 08 June 2003
Location: United Kingdom
Status: Offline
Points: 48 		Post Options Post Options   Thanks (0) Thanks(0)   Quote thedave Quote  Post ReplyReply Direct Link To This Post 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.



Edited by thedave
ello?!
Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post Posted: 09 July 2003 at 10:17am
Originally posted by kbannon kbannon wrote:

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?



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

L. Jamal Inc : Web/ Print Design and ASP Programming
Back to Top
Gemma Fairchild View Drop Down
Newbie
Newbie
Avatar

Joined: 19 June 2003
Location: United Kingdom
Status: Offline
Points: 32 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gemma Fairchild Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.