Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Difference between access and sql version
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Difference between access and sql version

 Post Reply Post Reply Page  12>
Author
quing View Drop Down
Newbie
Newbie


Joined: 10 October 2003
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote quing Quote  Post ReplyReply Direct Link To This Post Topic: Difference between access and sql version
    Posted: 10 October 2003 at 10:18am

i want to change from an access-version to an sql-version of the wwforums, but i dont want to make all the design changes again. can i keep the old asp-files and only change the db-connection in the common.asp file? or is there another big difference between these two versions?

would be very helpful, i could save alot of time

Back to Top
God_Struth View Drop Down
Senior Member
Senior Member
Avatar

Joined: 07 August 2003
Location: United Kingdom
Status: Offline
Points: 218
Post Options Post Options   Thanks (0) Thanks(0)   Quote God_Struth Quote  Post ReplyReply Direct Link To This Post Posted: 10 October 2003 at 10:26am
Depending on what changes you have made, then there shouldn't be a problem.
"I'm only trying to help......"
Back to Top
quing View Drop Down
Newbie
Newbie


Joined: 10 October 2003
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote quing Quote  Post ReplyReply Direct Link To This Post Posted: 10 October 2003 at 10:36am

only changes on the design (html).

a few mods (active users displayed on main page, recently joined members, latest posts,....) but they wont be difficult to change. the forum itself is the problem.

does only the db-connection change? the sql-queries and db-field requests work the same way, or not?

Back to Top
quing View Drop Down
Newbie
Newbie


Joined: 10 October 2003
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote quing Quote  Post ReplyReply Direct Link To This Post Posted: 10 October 2003 at 10:43am

if you want you can have a look at my work: www.futasia.ch

its a german site, actually i live in switzerland (we speak german) but originally i'm from vietnam. strange huh?

though its a new community-portal for asians, who live in switzerland and germany.

btw. i need the wwforum v.7.0.1 (sql-version) to upgrade my site. but cant download it anymore. can you help me? if someone still has this version please mail it to me (info@futasia.ch) or give me a link, where i can download it.

Back to Top
huwnet View Drop Down
Senior Member
Senior Member


Joined: 30 May 2003
Location: England
Status: Offline
Points: 1375
Post Options Post Options   Thanks (0) Thanks(0)   Quote huwnet Quote  Post ReplyReply Direct Link To This Post Posted: 10 October 2003 at 10:49am
You could always upgrade to WWF v. 7.5 there is not that much difference!
Back to Top
quing View Drop Down
Newbie
Newbie


Joined: 10 October 2003
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote quing Quote  Post ReplyReply Direct Link To This Post Posted: 10 October 2003 at 10:56am

really? but there are lots of included mods (navbar, who is online, latestposts,....) which wouldnt work anymore. it was really a hard piece of work to make all these features run.

someone give me that file, an i call him MASTER or GOD or whatever he wants

Back to Top
quing View Drop Down
Newbie
Newbie


Joined: 10 October 2003
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote quing Quote  Post ReplyReply Direct Link To This Post Posted: 10 October 2003 at 5:43pm

i only want to know, which asp files have to be changed, if i upgrade my database from access to sql-server. do i have to change lots of them or only a few? and which ones? i hope only the common.asp...

the reason is, as i said before, the mods and design changes i've made. most of them are not available yet for version 7.5

isnt there really nobody among the 6000 registered members, who has version 7.0.1 sql-server? please if there is someone send it to me (info@futasia.ch) or give me a link where i can download it.

@ADMIN: i know you are a very busy man, and you do a damn good job with this forum, but please take a second and send it to me.

 

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 11 October 2003 at 5:20am
I'm not sure about if mods will still run.

But in an unmoded forum all you need to do is enter your SQL server details into the SQL_server_connectioon.asp file in the admin area and change the database type in the common.asp files.

You will have to create the SQL server database with all the stored procedures.
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.