>>2- Do I understand that SQL Server counts ALL connections from one machine (or at least one VFP app) as "one user" in its licensing scheme? If that's the case, then I really don;t need to worry about having several connections open right? (at least not for licensing reasons)
>
>This is going to depend on what type of licensing that you installed the server under. If you are using PER SEAT licensing, the workstation can connect to any number of server. For PER SERVER licensing, the workstation has a license to connect to a specific server. I thought it was driven by the number of distinct clients, not connections - but I could be wrong.
>
The licensing is by the number of users, not connections. There is another issue with connections, though. Each connection does eat some resources on the server. If you have a connection for each view and a lot of users you can pretty quickly find yourself using 100s of connections. My preference is to limit to one connection per user if possible. The exception is when you want to execute queries asynchronously. Then you need multiple connections.