MS SQL Server ODBC - Re: ODBC error

Author

Re: ODBC error

iquality

2005-04-12, 7:23 am

We're getting the same exception in silverstream 2.5.4 / sql7. no
solution yet ?

--
iquality
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message115568.html

Warren Read

2005-04-20, 8:23 pm

I can understand your frustration with this. I have hundreds of tests that
run against all flavors of SQL Server, and I occasionally get this error.
It's not specific to SQL 6.5, either. When we rerun our tests, they pass
without issues. This error pops up at totally random times, so it's not
specific to a particular query.

We're working on solutions for our tests to try to automatically detect
this error and rerun the query that's failing, but frankly that's not
really practical (this would require millions of updates to our code). My
only suggestion for you is that hopefully your application can somehow
detect this message and re-execute the query that's deadlocked
automatically.

Sponsored Links