>Dear all,
>Do you know the difference between system DSN and user DSN
>used to connect to the SQL database ? Which one is better
>in performance ? I'm using VFP and VB to develop a
>client/server application.
>Thanks for help.

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.