01 February,2013 by Jack Vamvas
A regular question from application developers creating DSNs to connect to SQL Server database - what is the difference between a System DSN and User DSN ?
The quick answer is : A User DSN is available only to the user who created the DSN on the server . A System DSN is available to all users on the server
1) SQL Server and IIS require System DSN
2) You can use a DSN-less connection string and avoid creating a DSN
3) Both system DSN and user DSN are stored in the System Registry