First of all I would like to thank the creators of Snitz and the Snitz community for all the hard work that has been invested into Snitz.
Now. .on to my question:
I am trying to implement multiple forums within one SQL server 7 database. I have looked over the board for leads on how to accomplish this. There are some instructions for access 2000 here:
Following these instructions I would have thought that the procedure for SQL server would be:
Create new forum as per the ReadMe.txt in an empty SQL database. Placing the ASP scripts in a folder on your web server. I.e.: /forum1/ Run setup.asp?RC=5 to complete the procedure.
Then create a new directory for your second forum’s ASP scripts: I.e.: /forum2/ Edit config.asp Giving the tables a different prefix to the first forum instance. I.e.: FORUM2_ But leaving the connection string the same.
Run setup.asp?RC=5 of the second forum creating the new tables in the same SQL database as the first forum.
I now have two forums running in the same database inderpendantly of each other. Up to this point everything works fine.
However the forums still have separate member tables.
I assumed (and hoped) that to get the second forum to share the first forums member table it would be as simple as to change the second forums cofnig.asp to point at the first forums members table by changing the var on line 65 . ‘strMemberTablePrefix’ to point at the first forums member table? Upon changing the second config.asp to point at the first forums member table. I receive this error in default.asp of the second forum:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'FORUM_FORUM' does not match with a table name or alias name used in the query. /cca_dynamic/kt_forum/default.asp, line 211
Has anyone encountered and solved this problem? I'm hoping yes.. as in true developer style, I have told project management that I can do this allready!
Topic Locked
Posted - 17 June 2002 : 20:50:46
.