>Why do you want them to use the same instance? Even if it could be done (I don't know how it could), I don't think its a good idea- one application doesn't know what state the other application left it in.
I'll be using the COM to hit SQL Server and I could have dozens of users accessing at the same time. My concerns are 1) What is the impact on the server and performance to having so many COM instances opened at the same time, and 2) It would get expensive to purchase dozens of SQL Server client licences.
George