Need to run SQL software to run SQL vers?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8196
Printed Date: 07 April 2026 at 2:29am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Need to run SQL software to run SQL vers?
Posted By: adamb
Subject: Need to run SQL software to run SQL vers?
Date 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 |
Replies:
Posted By: Badaboem
Date Posted: 18 December 2003 at 12:26pm
|
You need sql server software. |
Posted By: thekiwi
Date Posted: 18 December 2003 at 12:40pm
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. ------------- Cheers TheKiwi http://www.infobahn.co.nz - Internet Infobahn - website design and hosting |
adamb wrote:Posted By: adamb
Date 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 |
Posted By: thekiwi
Date Posted: 18 December 2003 at 1:03pm
|
http://forums.webwiz.net/forum_posts.asp?TID=249&PN=1&TPN=1 - http://forums.webwiz.net/forum_posts.asp?TID=249&am p;PN=1&TPN=1 http://forums.webwiz.net/forum_posts.asp?TID=8171&PN=1 - http://forums.webwiz.net/forum_posts.asp?TID=8171&a mp;PN=1 ------------- Cheers TheKiwi http://www.infobahn.co.nz - Internet Infobahn - website design and hosting |
Posted By: Paul Lush
Date 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... |