Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLConnect() not working from COM object
Message
De
31/08/2005 20:51:46
Alan Harris-Reid
Baseline Data Services
Devon, Royaume Uni
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01044667
Message ID:
01045714
Vues:
28
Hi Joel,

>You've got to create a COM+ package for this in order to use impersonation for a user that has rights on the network (same is true for networked dbfs). There are some good instructions for this on the ActiveVFP site in the documentation.

Created a COM+ object to which I attached the .dll. It worked fine, but I got very frustrated trying to remove the COM+ object from memory each time I wanted to rebuild the project - probably something amiss on my part.

Anyway, meanwhile I changed MSDE from NT authentication to SQL authentication with a username and password. Worked a treat, so I have reverted back to 'old-fashioned' COM objects for now.

Regards,
Alan
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform