| Author |
 Topic  |
|
|
suzypud
Starting Member
United Kingdom
12 Posts |
 Posted - 15 March 2004 : 12:00:19
|
I get the following error regularly. I can access various pages of my forum with no problem, then suddenly this error is thrown up. If I refresh the page it is fine. This is beginning to drive me mad! Currently my forum is not available to my users, but at some stage I need to let them at it, and currently it is not up to scratch with this error appearing at random moments.
I have noticed some discussion about similar problems in the archives, but as no solutions were found, I'm reposting this problem.
The error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
Hope someone can shed some light on this.
|
Edited by - suzypud on 16 March 2004 07:52:21 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 15 March 2004 : 12:04:52
|
| I would start by suggesting that you use the SQLOLEDB provider, instead of using the ODBC one. That alone will improve performance. If the problem persists after doing that, come back for further help. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
suzypud
Starting Member
United Kingdom
12 Posts |
Posted - 16 March 2004 : 04:07:33
|
Ok - I'll give that a try ... once I figure out what the connection string should be when using SQLOLEDB, and get back to you.
Thanks  |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 March 2004 : 04:38:52
|
quote:
Originally posted by suzypud
Ok - I'll give that a try ... once I figure out what the connection string should be when using SQLOLEDB, and get back to you.
Thanks
You have it in the config.asp file. Have a look. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
suzypud
Starting Member
United Kingdom
12 Posts |
Posted - 16 March 2004 : 05:01:36
|
Not a success - just get slightly different error!
Microsoft OLE DB Provider for SQL Server error '80004005'
Timeout expired
I should mention that the database that Snitz uses is also used for a directory of staff I have, and I get the same errors with that aswell. I have several other databases on the same SQL Server, none of which have this problem. This is why I have begun to suspect that something dodgey is going on to do with Snitz. Could any settings have been altered when I installed?
Suzy |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 16 March 2004 : 06:08:49
|
| Might be worth just checking you have latest MDAC/JET Drivers installed, you can find them on Microsofts download site. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
suzypud
Starting Member
United Kingdom
12 Posts |
Posted - 17 March 2004 : 04:12:28
|
quote:
Originally posted by ruirib
Snitz does not change any DB settings. How big is the database where snitz tables are located?
Do you mean the size that you set when you create it? If so that's 100mb. Is that big enough? If I need to get it increased, what size do you suggest?
Suzy |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
