| Author |
 Topic  |
|
|
stef
Starting Member
37 Posts |
 Posted - 15 May 2002 : 04:56:28
|
I have a problem that I can't properly indentify.
Snitz Forum 2000 3.3.03 connected whith access mdb database (50MB/30 user in the same time/160 totally)
Sometimes the forum begins to function slowly and can't load de default.asp (the screen remains white)
I have to access the web server and stop-restart the WW3 service (internet information Server 4.0).
In this way the default.asp unblocks.
I presume that there is a defaulting interaction whith IIS 4.0.
This problem is unpredictable eand totally random, but it is very annoying.
Important: I have 2 snitz forum on the same server...when one can't load the default.asp, also the other is blocked!
I would be gratefull in you coold find a solution.
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 15 May 2002 : 05:24:34
|
Please post your connection string here. I would also advise you to visit Microsoft's site and download the lastest MDAC.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
stef
Starting Member
37 Posts |
Posted - 15 May 2002 : 08:20:45
|
Et voilà,
the connections string: I only deleted the full path of the databases whith some xxx...question of security.
String of forum more important
strDBType = "access"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=xx:\xxxxx\forumxxx\db\forumxxx.mdb" '## MS Access 2000
String of forum less important (older version of snitz F)
strDBType = "access"
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=xx:\xxxxx\forum\db\Forum.mdb" '## MS Access 97
What is "the lastest MDAC" ??
Thanks
By
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 15 May 2002 : 08:30:31
|
You can get all the info on Microsoft's Universal Data Access here: http://www.microsoft.com/data/prodinfo.htm
You can also take the chance and download it, as I suggested.
Another question: I saw that you are using an Access 2000 conn string, but is the database an Access 97 format DB or is it 2000? Is it the default DB that you downloaded with the Snitz code?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 15 May 2002 08:31:11 |
|
|
|
stef
Starting Member
37 Posts |
Posted - 15 May 2002 : 08:50:29
|
Where I use an Access 2000 conn string, the database is yet an Access 97 format DB...I Try to convert in a 2000 format but become so bigger! (from 50Mb to 75Mb!)
The db is the basical db whith only some small modification (I must ask to my SW Developer)
Bye
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
alex042
Average Member
USA
631 Posts |
Posted - 15 May 2002 : 10:11:20
|
If you're concerned over security or users, you may consider setting up a DSN in IIS for your database and using a DSN connection string instead. Also, Access has a concurrent user limitation, so you may want to consider upgrading to MS SQL.
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 15 May 2002 : 13:13:14
|
Also a DSN uses an ODBC driver that, besides being slower, is usually less robust than an OLEDB one, which would lead to the situation stef started with...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
| |
Topic |
|
Topic Locked
Nathan Bales