I have a C# program, accessing SQL Server2000(SP3) on another machine.
If i do not close the connection, then after at about 4000 connection, it may display error messageystem.Data.OleDb.OleDbException[ConnectionOpen[Connect()].]SQL Server does not exist or access denied. Maybe the number would be more than 5000 before it ran into error. but in most situation it was at about 4000.
Of course, if i put the program and the DB at the same machine, the error message does not appear, but the memory was used so fast, even each the memory limitation and report: out of memory.
I had read from material that SQL Server can handle 32676 connections simultaneously. and Why did i get the error when the program and DB was in two different machine?