Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multi-user access to one COM instance?
Message
 
À
05/04/2000 15:06:33
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00355750
Message ID:
00355954
Vues:
25
>You can't bypass the SQL server license model just by moving a COM component to a common machine. 10 users accessing a database is still 10 users accessing a database. If the serveer is out of proc, or hosted in a MTS package, you can use DCOMCNFG to change the account that the server will impersonate while it operates, but I don't think that this helps the instance/connection situation.

This app is built on a VFP database and updates to SQL Server only when a save is done. (I can explain why I am using this model if you like.) Rather than having each user having a connection to SQL Server (or opening and closing connections to do saves) I wanted to send all requests to update SQL Server to a COM on the server that would maintain one open connection to SQL Server.

This a multi-thread out process COM. (I do not see a way to access a DLL sitting on the server, maybe I am missing something.) I tried setting the COM Identity property in DCOMCNFG but that only servered to allow access only to the user set in this property.
George
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform