| ipramod@gmail.com 2006-12-05, 5:16 am |
| Hi,
I am using ADO provider for connecting to SQL Server 2000 in my C++
app. I am opening and closing the connections properly. I am using MDAC
Version 2.82.1830.0. When I run my app on my local machine, there is no
connection leak. But when I use the same code on test machine I get
connection leak and an exception 80004005 [unspecified error] is
caught. I get Error 16945,16955,208 on SQL Profiler. I am using Cursors
in SQL Queries. I am deallocating cursors. It seems to leave open
connections behind time to time, it sums to hundreds over a day (the
application make thousands) on test machine.
Is there any difference when we use (local) or localhost in connection
strings of SQL Server 2000? Is there any limit on maximum length of the
SQL Query?
One more thing, the same code is working for SQL Server 2005 test
machine. There is no connection leak on the SQL 2005 machine.
Please let me know ASAP.
Thanks,
Regards,
Pramod
|