Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bor
Starting Member
3 Posts |
 Posted - 2008-02-28 : 04:17:24
|
| Hi,I have strange situation with one procedure on MS SQL Server 2000, sp3: - It's some old procedure that worked well for several years- It still works at other locations (even on MS SQL Server 7)- Now sometimes this procedure just stops working over ODBC and OLE-DB connection. From Query Analyzer it works always ok! Over ODBC looks like client doesn't receive information, that procedure has completed. I put some insert at the end of the procedure (for debbuging): procedure executes insert (it's the last statement in procedure), I can select inserted values from table, but client just doesn't get answer from server. I looked all processes at SQL Server and none of them is blocked, there are no locks that prevents procedure execution,... I found out that recreating procedure makes it working again (for all clients). Well, at least for few days or even weeks. Any ideas?Thx! Borut |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 23:18:32
|
| Did you check mdac version on client machines? |
 |
|
|
bor
Starting Member
3 Posts |
Posted - 2008-03-03 : 03:12:17
|
quote:
Originally posted by rmiao
Did you check mdac version on client machines?
Currently we use MDAC 2.7 RTM on machines with Win 2000. XP computers have higher versions (2.8, 2.8 with SP1,...). |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-03 : 03:44:57
|
And which machines appears to fail?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
bor
Starting Member
3 Posts |
Posted - 2008-03-03 : 09:09:38
|
[quote]Originally posted by Peso
And which machines appears to fail?All. It doesn't make any difference from which client we're trying to run stored procedure. It helps just to recreate procedure on server... no actions on client side needed to make it work again. Ah - just to mention again - from MS Query Analyzer works all the time (from all clients). |
|
|
|
|
|
|
Stored procedure never ends