Question:
I have 20 user licenses. During some activities, users are being logged in two or three times. Thus I can hit a max user limit with only 9 actual users. Any suggestions on what to look for to minimize this? We are runningSQL Server 6.5 and 7.0 as “back-end” linked to Access via ODBC as “front-end”.
Answer:
There are technologies now that allow something called pooling, where connections are shared between users. MTS keeps connections alive after they are used so that they can be re-assigned to new users. Also, your application’s architecture could have an influence on how many connections are created and how they are used.