WWF resides on separate server from SQL
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=5331
Printed Date: 02 April 2026 at 10:48pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: WWF resides on separate server from SQL
Posted By: Bansheigh
Subject: WWF resides on separate server from SQL
Date 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 = |
Replies:
Posted By: MadDog
Date Posted: 27 August 2003 at 5:59pm
|
huh? ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: Bansheigh
Date 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 |
Posted By: MadDog
Date Posted: 27 August 2003 at 6:11pm
|
Since you changed hosts you are going to have to change the connection string. ------------- http://www.iportalx.net" rel="nofollow">
|
Posted By: fernan82
Date 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. |
Posted By: wistex
Date 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. |