| Author |
 Topic  |
|
|
Astralis
Senior Member
USA
1218 Posts |
 Posted - 09 February 2005 : 19:14:54
|
Now that I've switched from Access to SQL, I get this error on any search:
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/forum/search.asp, line 376
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 February 2005 : 05:05:31
|
| the reason it is timing out is because the sql server you are using is underpowered for the traffic it gets. |
 |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 10 February 2005 : 16:58:44
|
hmm...interesting. Do you see a problem with this? Do you think CT would entertain the idea of scaling back the number of dbs per server?
Ruirib, thanks...your page works and the search function is great.
Podge, I'm not sure what the server is on. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 February 2005 : 19:27:19
|
quote:
Originally posted by Astralis
hmm...interesting. Do you see a problem with this?
Of course. It's not the same dividing CPU and RAM through a dozen DBs or hundreds of them.
quote:
Do you think CT would entertain the idea of scaling back the number of dbs per server?
They should, but I don't think they will.
quote:
Ruirib, thanks...your page works and the search function is great.
You're welcome. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
CalloftheHauntedMaster
Junior Member
289 Posts |
Posted - 09 June 2005 : 15:58:10
|
I have the same problem:
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/bbs/search.asp, line 376
Ruirib, I searched and I didn't find the mod that was supposed to correct this. If someone can link me to where I can find the solution, I'd greatly appreciate it because I've been having this problem for a while now without any successes. |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
CalloftheHauntedMaster
Junior Member
289 Posts |
Posted - 09 June 2005 : 16:51:41
|
I'm not familiar with connection strings. How would I change it?
Also, would changing to SQLOLEDB require me to change anything else major, or is this a relatively simple procedure?
|
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - CalloftheHauntedMaster on 09 June 2005 16:52:56 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 June 2005 : 16:53:46
|
Have a look in config.asp. There are examples there and you can use the similar values from your current ODBC string.
You should change the connection string regardless of the issue with search. OLEDB drivers are always faster and more robust than ODBC. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
CalloftheHauntedMaster
Junior Member
289 Posts |
Posted - 09 June 2005 : 16:59:45
|
Here's what I have in config.asp. Since you're the expert in these things and I'm not even close, what would need to be changed? Basically, I'm just trying to fix the search, and nothing else. This is still new to me and I don't want to recode the whole server just to fix the search feature.
Code removed by ruirib |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - ruirib on 09 June 2005 18:14:06 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 June 2005 : 18:18:41
|
What's the point of posting a whole file just because of a single connection string line?
We strongly discourage direct code posting, when the code is large in size. In those circunstamces, always post the code as a link to a text file. Also I do not think it's a wise move to post your SQL Server access data, unless you want someone to connect to your database.
Use this connection string:
strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;"
Replace SERVER_NAME, DB_NAME, UID and PWD by the corresponding values from your current connection string.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
CalloftheHauntedMaster
Junior Member
289 Posts |
Posted - 10 June 2005 : 14:33:25
|
Well, my current connection string looks like this:
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
My problem is that there are three other strings that look like this:
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0
Am I supposed to replace the "Microsoft.Jet.OLEDB.4.0" with "SQLOLEDB" on all three of those strings? |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 June 2005 : 16:16:42
|
| That was not the uncommented string in your posted config.asp and that could not be the string you had when the error ocurred. It's not possible that an error with the ODBC driver occurs if you're using an OLEDB provider! |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
CalloftheHauntedMaster
Junior Member
289 Posts |
Posted - 10 June 2005 : 16:30:20
|
Well, this is the error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/bbs/search.asp, line 376
Ruirib, is there some way I can show you the connection strings in private and you'll help me understand what's wrong??? |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - CalloftheHauntedMaster on 10 June 2005 17:26:48 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
