It sounds like you are not properly closing your connections, statements, or something like that.
We're using SQL Server 2000 and process over 100 million DB operations a month with no issues.
One word of caution, eventhough many people say you do not have to close Statements, PreparedStatements, or CallabelStatements before closing Connections: do it. It does matter. Don't leave it up to the driver to handle this. We've found vast differences in how drivers handle this, especially the MS Type 3 Driver, which is aweful BTW. [ November 04, 2004: Message edited by: David Yutzy ]
subject: I am facing a lot of problems with sql server 2000 odbc drivers.