Print Page | Close Window

1 Database for my forums

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=6032
Printed Date: 03 April 2026 at 11:30am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: 1 Database for my forums
Posted By: FARSHAD
Subject: 1 Database for my forums
Date Posted: 28 September 2003 at 11:06pm

hello

I have 2 forums

and 1 database 

database name   is   test34.mdb

and my first forum folder name is  > forum0

and second is  > forum1

and they are in a folder with this name   > forum

and database is in a folder with this name  >  test00

and this folder is in the ( forum ) folder

this is

============

Forum ----   > the main folder

       ----forum0        &g t;>>    and subfolders

       ----forum1

       ----test00 ---- test34.mdb

==============

what i must to write exactly  in the 2 common.asp files

until my 2 forum use 1 database

i don`t know anything about ASP and database

pls write for me what i must to do

===========

Thank you

 




Replies:
Posted By: Phat
Date Posted: 28 September 2003 at 11:18pm

In common.asp

'Set up the database table name prefix and stored procedure prefix
'(This is useful if you are running multiple forums from one database)
' - make sure you also change this in the msSQL_server_setup.asp file if setting up an ms SQL server database)

Const strDbTable = "tbl"
Const strDbProc = "wwfSp"

Change strDbTable to the new table prefix you use in your access database. You will need to make new tables with the new prefix.

Also change
strDbPathAndName = Server.MapPath("path_to_your_database")

I have never done this before so i am guessing a bit but that seams like what you have to do.

James


 



-------------
http://buildit.sitesell.com/sitebuildithome.html - Get a website that sells


Posted By: fernan82
Date Posted: 29 September 2003 at 12:25am
Do you have any reason for wanting to share the same access database for two forums? I don't think that's a good idea...


Posted By: DragonFist
Date Posted: 29 September 2003 at 2:46am

he might do this for "Skins"

one Dark Forum and one Bright Forum....just guessing =\



-------------

Legends Live Forever


Posted By: fernan82
Date Posted: 29 September 2003 at 7:31pm

ohh ok, i thought he was talking about running two different forums of the same access database...

In that case all you need to do is change the database path on commo.asp.



Posted By: MadDog
Date Posted: 29 September 2003 at 7:48pm
This thread makes no sense.

-------------
http://www.iportalx.net" rel="nofollow">


Posted By: fernan82
Date Posted: 29 September 2003 at 7:54pm

Originally posted by MadDog MadDog wrote:

This thread makes no sense.

may I ask why?



Posted By: wistex
Date Posted: 29 September 2003 at 8:43pm

I am not sure what he is doing, but one possible use for this type of configuration is to allow multiple websites to share the same forum, yet have their own look and feel.  That way, when people post in one website, their post appears on the other, and vice versa.  As a result, the forum builds more users and more posts than it would otherwise.  And more users and more posts attracts more users and more posts.  It speeds growth.

Actually, I have seen this done before with a forum, and it worked quite well for them.  Within a year, their forum has become quite busy.  They currently have about a dozen websites who have their own skinned version of the forums all sharing the same database.

I liked the idea so much, that I am going to do the same with one of my forums. We are already putting together a package that will allow websites that complement ours to have our forums on their website.  This arrangement is great for smaller sites who want the stickiness that a forum creates, yet does not have enough traffic to generate enough posts to sustain an active forum, yet has enough traffic to bring new members and posts.

Plus, as an added bonus, our website, which we are developing into a portal, will get recognition and advertising on other websites.  It's a win-win situation.

(Wow! This is my 100th post!)



-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums


Posted By: madolik
Date Posted: 10 October 2003 at 4:22pm

I want the forum database (access-version, 7.01) to be accessible from a different website.

I tried to change both, the absolute and relative database path in common.asp. Doesn't work.

Lets say that the second database is stored on http://xyz/wwforum.mdb - http://xyz/wwforum.mdb .

What changes must be made in common.asp to access this db? The common.asp and the whole forum is on a completey different web.site - and not on http://xyz - http://xyz . Only the db is  stored there.

I'd be glad for some help...



Posted By: WebWiz-Bruce
Date Posted: 11 October 2003 at 5:25am
For security reasons under normal cercumstances you can not connect to an access database on another web site. The path must be a path on the same web server or local mapped network drive.

I do believe there are a few tricky work arounds to this, but you would have to look them up on google.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net