>We are designing our SQL 7 implementation (while we are still learning it)& have decided on the following regarding connections. Our remote views will share connections & our SPT will use 1 connection that is opened up in the logon process. This 1 connection will remain open through out the appslication session. Are there any potential problems with this that anyone can see?
You will limit the number of users that can be working on the application to the number of client licenses you've got for SQL Server. Not to mention if there are any other applications running on the same server.