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=Con...r=&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:
[vbcol=seagreen]
> Hi
> Not much to go on, so look at
> http://groups.google.ch/groups?q=Con...r=&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: