ODBC Locking

We have an application using ODBC to SQL Server 2000. It
does not appear to release locks properly. From speaking
with the developer, I think the driver may be adding to
the problem by adding "set implicit_transactions on".
Could this be? Has anyone else seen this problem?
Thanks,
JoelTransactions are not handled the way you would think in ADO. The following
KB article describes the issue:
http://support.microsoft.com/default.aspx?scid=kb;en-us;198024
For a single statement there is no noticible difference. When you start
nesting commands and walking through cursors it can rapidly expand a
transaction far past what you think it does.
Enjoy,
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Joel" <joel.griffin@.teijinmonofil.com> wrote in message
news:418601c3560d$607faed0$a001280a@.phx.gbl...
> We have an application using ODBC to SQL Server 2000. It
> does not appear to release locks properly. From speaking
> with the developer, I think the driver may be adding to
> the problem by adding "set implicit_transactions on".
> Could this be? Has anyone else seen this problem?
> Thanks,
> Joel