Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Any MODs for SQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Any MODs for SQL
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
hgurol View Drop Down
Newbie
Newbie
Avatar

Joined: 29 January 2004
Location: Turkey
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hgurol Quote  Post ReplyReply Direct Link To This Post Topic: Any MODs for SQL
    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?
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post 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



Edited by Semikolon
Back to Top
hgurol View Drop Down
Newbie
Newbie
Avatar

Joined: 29 January 2004
Location: Turkey
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hgurol Quote  Post ReplyReply Direct Link To This Post Posted: 30 January 2004 at 3:41pm
Originally posted by Semikolon Semikolon wrote:

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

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
Back to Top
hgurol View Drop Down
Newbie
Newbie
Avatar

Joined: 29 January 2004
Location: Turkey
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hgurol Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
hgurol View Drop Down
Newbie
Newbie
Avatar

Joined: 29 January 2004
Location: Turkey
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hgurol Quote  Post ReplyReply Direct Link To This Post 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...
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post 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..
Back to Top
hgurol View Drop Down
Newbie
Newbie
Avatar

Joined: 29 January 2004
Location: Turkey
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hgurol Quote  Post ReplyReply Direct Link To This Post 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 :)
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.