Connection error

S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for
another hstmt
How to resolve this error.Hi
Not much to go on, so look at
http://groups.google.ch/groups?q=Connection%20is%20busy%20with%20results%20for%20&hl=en&lr=&sa=N&tab=wg and see if anything there solves your problem.
When you post, please post more information as errors like this can be
cuased by many problems.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Geeta" wrote:
> S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for
> another hstmt
> How to resolve this error.|||Hi Mike,
The links given by you were of great help. I was using the same
connection object for multiple threads. I used a new connection object and
the issue is now resolved.
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Not much to go on, so look at
> http://groups.google.ch/groups?q=Connection%20is%20busy%20with%20results%20for%20&hl=en&lr=&sa=N&tab=wg and see if anything there solves your problem.
> When you post, please post more information as errors like this can be
> cuased by many problems.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Geeta" wrote:
> > S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for
> > another hstmt
> >
> > How to resolve this error.