| Author |
 Topic  |
|
|
twd76
Starting Member
2 Posts |
 Posted - 18 February 2004 : 14:11:26
|
I need to have 2 totally separate forums for 2 separate set of users. Is this possible using the same SQL Server database?
Thanks in advance! |
|
|
NorwegianViking
Junior Member
Denmark
119 Posts |
Posted - 18 February 2004 : 16:11:30
|
That should be easy.
In SQL server you can have as many databases you like.
Two different databases. Each with a complete set of the DB's
Two different directories on your server, with duplicate instances of the forum SW, and then two different config.asp with points to each db. |
kind regards
NorwegianViking
Mod installation for beginners | User registration problems?
|
 |
|
|
Radianation
Junior Member
USA
186 Posts |
Posted - 18 February 2004 : 16:31:46
|
| So you just set the prefix from forum_ to something like forum1_ forum2_ etc ?? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 February 2004 : 19:29:59
|
You can, in fact, have two forums in the same database. There have been posts in the past that describe precisely what to do to achieve that. Try using the search.
NorwegianViking, with an hosting account is not that common to have more than a database. In that case, it's possible to use the same DB, and Snitz allows it through the use of table prefixes. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 February 2004 : 19:40:29
|
Here is such a post: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=49982&SearchTerms=2,forums,1,DB
However, with SQL server, things are much simpler. Just do this:
1. Create a new folder and copy the forum files there.
2. Open the config.asp file for the second forum and change the value of the variables strTablePrefix, strMemberTablePrefix and strFilterTablePrefix to FORUM2_.
3. Run setup.asp now. Specify a user name and a password to the admin.
4. If setup went well, and if you want to have the same members to both forums go to config.asp again and set strMemberTablePrefix to the initial value (likely FORUM_, if you haven't changed it when you first setup your first forum. If you don't want to have the same set of members, skip this step altogether.
5. If having the same set of members, you can now delete FORUM2_MEMBERS. If not, you're done.
6. You should have two working forums in the same DB, now. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
twd76
Starting Member
2 Posts |
Posted - 19 February 2004 : 15:40:50
|
Thanks, ruirib ... that's exactly what I needed to know.
I must humbly admit that after reading your post I went back to the readme.htm and found the information in there. I should have thought about that before posting. Sorry! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
