WWF resides on separate server from SQL

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Bansheigh Members Profile Find Members Posts Newbie Joined: 27 August 2003 Status: Offline Points: 3	Post Options Post Reply Quote Bansheigh Report Post Thanks(0) Quote Reply Topic: WWF resides on separate server from SQL Posted: 27 August 2003 at 5:07pm
	have tried to change the db path in common.asp with no luck on getting a connection. Can anyone pls advise on the correct structure of the path for SQL? StrCon =

MadDog Members Profile Find Members Posts Mod Builder Group Joined: 01 January 2002 Status: Offline Points: 3008	Post Options Post Reply Quote MadDog Report Post Thanks(0) Quote Reply Posted: 27 August 2003 at 5:59pm
	huh?


Bansheigh Members Profile Find Members Posts Newbie Joined: 27 August 2003 Status: Offline Points: 3	Post Options Post Reply Quote Bansheigh Report Post Thanks(0) Quote Reply Posted: 27 August 2003 at 6:05pm
	sorry should have included this earlier, original setup was done on a test server and we have migrated the associated db to the permanent SQL server. In migrating the boards, they will no longer connect to the db. Having trouble getting the boards to connect to something besides /localhost/ ps we are using the SQL version of WWF

MadDog Members Profile Find Members Posts Mod Builder Group Joined: 01 January 2002 Status: Offline Points: 3008	Post Options Post Reply Quote MadDog Report Post Thanks(0) Quote Reply Posted: 27 August 2003 at 6:11pm
	Since you changed hosts you are going to have to change the connection string.


fernan82 Members Profile Find Members Posts Mod Builder Group Joined: 17 November 2002 Location: United States Status: Offline Points: 362	Post Options Post Reply Quote fernan82 Report Post Thanks(0) Quote Reply Posted: 27 August 2003 at 9:38pm
	The forum comes with a file called SQL_server_connection.asp on the admin folder where all you have to do is enter your SQL server name, username, password, and database name and the connection string is already built for you... all you have to change on the common.asp is the database type from Access to MSSQL and ignore the access connection string as it's not used on the sql version. Edited by fernan82

wistex Members Profile Find Members Posts Mod Builder Group Joined: 30 August 2003 Location: United States Status: Offline Points: 877	Post Options Post Reply Quote wistex Report Post Thanks(0) Quote Reply Posted: 01 September 2003 at 5:02am
	I think you are modifying the wrong part of the file. There is a section for configuring a local database that is commented out, and you want to ignore that. You need to just change the section for SQL. You will have to read closely to figure out which is which. I just set-up the forum todayand my database is on one server and the forums are on another. I had no problem, but I did have to specify the correct settings and it worked fine.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

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.