Question: what is the difference between system dsn and user dsn?
Answer: A User DSN is only accessible by the user who created it on the workstation. A System DSN is accessible by any user logging into the workstation. A File DSN is shared between all users that have the same drivers installed. ... A User or System DSN is recommended for consistent performance when using ODBC.