Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Need to run SQL software to run SQL vers?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Need to run SQL software to run SQL vers?

 Post Reply Post Reply
Author
adamb View Drop Down
Newbie
Newbie


Joined: 04 December 2003
Location: United States
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote adamb Quote  Post ReplyReply Direct Link To This Post Topic: Need to run SQL software to run SQL vers?
    Posted: 18 December 2003 at 12:23pm

Do you need to own and be running SQL server software to use the SQL version of WWF? Or can you have it work after just setting up an ODBC connection.

Thank You



Edited by adamb
Back to Top
Badaboem View Drop Down
Senior Member
Senior Member


Joined: 12 April 2002
Location: Netherlands
Status: Offline
Points: 600
Post Options Post Options   Thanks (0) Thanks(0)   Quote Badaboem Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2003 at 12:26pm

You need sql server software.

Back to Top
thekiwi View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
Post Options Post Options   Thanks (0) Thanks(0)   Quote thekiwi Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2003 at 12:40pm
Originally posted by adamb adamb wrote:

Do you need to own and be running SQL server software to use the SQL version of WWF? Or can you have it work after just setting up an ODBC connection.

Thank You

You need "access" to a SQL Server .. whether it is on the same machine, in a server farm etc etc.  f you use ODBC  ... then the server you connect to will have to be SQL Server.

Back to Top
adamb View Drop Down
Newbie
Newbie


Joined: 04 December 2003
Location: United States
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote adamb Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2003 at 12:46pm

OK. I think I understand. You need to be running SQL server software somewhere to run the SQL version of WWF.

My situation is I want to eventually use this commercially for a website that will have approx. 150 users, though not all logging on at the same time. Generally I hear Access can't handle db activity of that nature. Is that true? Is there any official documentation from WWF that suggests which platform (Access or SQL) to use for a certain expected number of users and posts? Suggestions?

Thanks



Edited by adamb
Back to Top
thekiwi View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
Post Options Post Options   Thanks (0) Thanks(0)   Quote thekiwi Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2003 at 1:03pm
Back to Top
Paul Lush View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 24 September 2003
Status: Offline
Points: 59
Post Options Post Options   Thanks (0) Thanks(0)   Quote Paul Lush Quote  Post ReplyReply Direct Link To This Post Posted: 19 December 2003 at 9:26am
The SQL version of the forums does a lot of table lookups via Stored Procedures which are generally a lot faster.  Access doesnt support these, hence the two difference versions.  As of version 7.6, the active users online was moved out of the database, this should reduce the chances of database corruption.  You would think that after 10 years, Microsoft wouldve got it right...
Back to Top
 Post Reply Post Reply

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.