Access and ODBC
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=20776
Printed Date: 28 March 2026 at 5:58pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Access and ODBC
Posted By: gaz8203
Subject: Access and ODBC
Date Posted: 22 July 2006 at 12:34pm
|
Is it best to connect the database to the ODBC if im using the MS Access version of the forum?
The reason I ask is, sometimes the forum doesnt let anyone post (and a few othere minor problems) if there are more than 6-7 people on at a time, and have been told that ODBC is the answer, but I dont know how ODBC works!
 |
Replies:
Posted By: dpyers
Date Posted: 22 July 2006 at 1:27pm
|
Nope. ODBC basically creates a DSN with the connection details. A request first locates the DSN and then uses it to locate the DB. There's server overhead associated with loading, accessing, and closing the DSN. Using the DSN-less method (specifying the path to the db) recommended by WWF directly connects to the DB and avoids the extra overhead. It's the Access Jet engine that handles the concurrent users, not ODBC. MS Access is a very flakey DB to use in a shared environment. Performance and stability will be influenced by such things as the load created by too many sites on the shared server, the number of posts in the forum, the number of forums, the number of threads... etc. The number of users is just one factor but there's dozens of ways to max out an acccess db. Turn off friendly http errors in your browser and post the actual error messages. Might help isolate what the problem is. EDIT: - the followup error messages should be posted as a separate thead in the support forum for the WWF version you're using. You'll get more viewers there. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: gaz8203
Date Posted: 22 July 2006 at 3:12pm
|
Ahh... there is no error message, its just what the forum users tell me. They just said that when they post a message sometimes it doesn't post or when they login they have to try many attempts.
Maybe the sql version would be better, maybe it is just the access version can't handle it!
Thanks for your help
 |