Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Difference between system DSN and user DSN
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00570026
Message ID:
00570051
Vues:
26
>No difference in performance. The only thing is where in the registry the DSN is located (and from where it is available).
>
>A user DSN is saved into HKCurrentUser and available only when the user in which the DSN is created is logged.
>
>A system DSN is saved into HKLocalMachine and is available to every logged user.

Theoretically, I agree. However, I have had no problem logging in on someone else's computer using my UserID and still having a USER DSN available that was created under another User's ID. FWIW, I always create User DSNs. These were Win9x computers.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform