Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Sever Crashes		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

skylar
Starting Member

23 Posts
Posted - 21 May 2001 :  18:13:14  Show Profile
I'm running Snitz on a Windows NT4 Server with the Access database and every couple days it seems to crash the server's asp.dll causing the site to go down. Anybody ran into this problem before or have any suggestions? (The site gets lots of hits, if that makes a difference)

BuffyNET
Junior Member

United Kingdom
126 Posts
Posted - 21 May 2001 :  18:18:52  Show Profile  Visit BuffyNET's Homepage  Send BuffyNET an ICQ Message
Have you installed any mods or anything?
If so go through and make sure they close the databases, I know all of te Forum Base code does close the Connections but I have heard of some mods not doing so

Neil
Go to Top of Page

skylar
Starting Member

23 Posts
Posted - 21 May 2001 :  18:21:43  Show Profile
Yes they all close. Someone told me that Access databases can only handle 5 simutaneous users before it crashes. Is this true?
Go to Top of Page

BuffyNET
Junior Member

United Kingdom
126 Posts
Posted - 21 May 2001 :  18:24:20  Show Profile  Visit BuffyNET's Homepage  Send BuffyNET an ICQ Message
Iv'e always been told it is closer to 15 or 20 and I thought it just crashed the Database and not the ASP dll, although I could well be wrong

Neil
Go to Top of Page

skylar
Starting Member

23 Posts
Posted - 21 May 2001 :  18:25:42  Show Profile
Do you know how to convert the MDB snitz database to MySQL without losing all the member info? Is this possible?
Go to Top of Page

BuffyNET
Junior Member

United Kingdom
126 Posts
Posted - 21 May 2001 :  18:29:33  Show Profile  Visit BuffyNET's Homepage  Send BuffyNET an ICQ Message
There is a topic going in the MySQL help forum about how to do this check it out :

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=6456&FORUM_ID=73&CAT_ID=10&Topic_Title=Access+to+MySQL&Forum_Title=Help%3A+Database%3A+MySql



Neil
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 21 May 2001 :  20:59:33  Show Profile
Access is pretty good when everything is configured properly. Make sure your IIS and Scripting engine are all at the latest version. Make sure your MDAC is at the latest version.

You can play with settings in your connection string for maxbuffersize and threads which may help on a busier site. There are some KB articles but in general you can increase the number of threads and the amount of memory buffer space allocated to the Jet driver.


======
Doug G
======
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07