Any MODs for SQL
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=9393
Printed Date: 28 March 2026 at 11:57am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Any MODs for SQL
Posted By: hgurol
Subject: Any MODs for SQL
Date Posted: 30 January 2004 at 3:17pm
|
Hi, very new here and to the WWF. Im planning to use it with MS SQL. I have looked for a few MODs but all I can see is only access designed MODs. I dont want to stick into the base forum and not being able to applying MODs is not nice, however I want to have all the benefits of a more powerfull DB server. Is there any MODs avaliable for MS SQL db based forums, maybe I dont know how to look for them? |
Replies:
Posted By: Semikolon
Date Posted: 30 January 2004 at 3:28pm
|
most of them will work with ms sql if you change the connectionstring and add tables/fields to your ms sql database and not all mods are database dependent |
Posted By: hgurol
Date Posted: 30 January 2004 at 3:41pm
Thats good news however setting up the db manually will take time. built scripts would be great for non-sql guys like me. Anyway I believe, I'll figure-out how to if start to play right away....thx |
Semikolon wrote:Posted By: hgurol
Date Posted: 30 January 2004 at 5:09pm
|
this doesnt work :( Im trying to implement web_wiz_site_news_access2000_v3.06 into my SQL but the access file this MOD has a table named "tblConfiguration" and has a primary key on the "username" field. But in the SQL db I have the forum on already has a different designed table, named also "tblConfiguration", it has a primary key on a field "website_name". Since their primary keys are on different named fields; there is no way to merge the configuration into one table. The only solution here to create another db on the SQL and move all the degisn from access file to that SQL db. Export/Import utility works to copy the degisns with some errors, specially it returns some errors with the no primary key assigned tables of access file. Anyway still this method is easier than doing everything manually. The problem is I dont want to and can not create a new db on the SQL everytime I install a mod. I dont want to do it because I want my all data to be on one SQL DB, which is better, more tidy, more managable etc. And I can not do that because my host only allows me one SQL DB and would charge me more money if I create the second one. I believe this is the case for most of the hosting firms. Do you see what I mean now; these MODs are not designed for MS SQL users of the forum. Right now Im stucked with this MOD and I have just started, dont know whats gonna happen with the other ones. I know its not logical when there is SQL avaliable for my usage, but I started to think about using access :( it really bothers me... I hv already posted the "site news mod problem" part to the "Web Wiz Guide's Free Applications" forum since its too specific and I guess it belongs to there. I would like to hear from MS SQL users of this forum; what kind of problems awating for me about the MODs? I want to make my DB desicion before my project goes to depth and live. I dont want it but now access seems to be the right choice for the functionalty. Any MS SQL users, enlighten me please.......thx |
Posted By: Semikolon
Date Posted: 30 January 2004 at 6:57pm
| yo.. those free apps isnt forum mods.. theyre standalone apps.. was never made to work together with the forum without modification.. but if you do as i told you in private it should work fine |
Posted By: hgurol
Date Posted: 31 January 2004 at 7:45am
|
hmmm thats ok but I still want to hear some comments from the SQL users in general. Probably my trafic will not force me to MS SQL, so maybe its better for me to continue(or start :)) with ms access. Share your experiences pls... |
Posted By: Semikolon
Date Posted: 31 January 2004 at 8:05am
|
im an SQL user too.. if you have one database, and two tables with the same name, but different data, the only way to run those tables seperately is to rename one of them.. you could also merge them together.. but that may be more work.. if your SQL database is free with the hosting, you should go for SQL.. not access.. |
Posted By: hgurol
Date Posted: 31 January 2004 at 8:26am
|
I wont pay for an extra if I use SQL, so why not I should go for it? Well the biggest issue here is; it might be hell to MOD the forum and customize it with SQL. As fas as I see the SQL support for the forum and the add-ons, mods etc. is very limited here :( thx semi... anyone else pls ? You seem to be the only one using SQL I guess :) |
Posted By: Mart
Date Posted: 31 January 2004 at 8:29am
|
Have a read of this: http://forums.webwiz.net/forum_posts.asp?TID=9087&PN=1 - http://forums.webwiz.net/forum_posts.asp?TID=9087&a mp;PN=1 |
Posted By: ljamal
Date Posted: 31 January 2004 at 8:51am
|
Any mod that works for Access should also work for MSSQL as well. The only major difference is the way the two databases format dates in the SQL statement. There are lots of minor difference, but if you have a problem you can always post it someone with MSSQL experience (like myself) will always be glad to answer your question. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: Semikolon
Date Posted: 31 January 2004 at 9:12am
you dont need to mod the forum.. the forum is already ready for SQL.. and most mods use the same connection that the main forum, so you just apply the mods as you would do with access... but if MODs is WWG Free apps, you will have to do it like i said! or setup a new database.. Your host may also upgrade your database for you if you upload the access db to them
and i dont think i am the only one who use SQL here..... |
Posted By: hgurol
Date Posted: 31 January 2004 at 10:21am
|
big thx to everyone, gonna start working with MS SQL...
Dont take my every sentence this straight, I was just teasing ;) |