MS Access Vs SQL Server

I'm using asp.net with MS Accessand I noticed that I need to close the connection (MANUALLY)after the use because I can have only 64 open connections. Does SQL Server needs to close the connections manually or automaticaly?How many open connections does SQL Server support?

 

Bruce... I have to give you credit for showing great restraint and not going into your "don't use access" argument (as valid as it is).


Bruce is right, you always want to close your connections. Some people can semi-effectively use Access to drive their websites, but it is even MORE imperative to close connections in Access, as there is a limited number of concurrent connections (as you have found out). If you open the connection, run your query, use your data, then close your connection right away, you can get it working pretty well.


So not only is your code cleaner, it runs better as well.



Mike Reilly, Secretary/Webmaster
Kiwanis Club of Rancho Penasquitos
"Serving the Children of the World"
[email protected]
(760) 419-7429