What is the difference between System DSN, User DSN, and File DSN when working with Open Database Connectivity (OBDC)?
What is the difference between System DSN, User DSN, and File DSN when working with Open Database Connectivity (OBDC)?
Introduction
When working with the Database building block in Leapwork, users need to create a database connection. A common question is how to choose between a System DSN, User DSN, or File DSN when configuring a database connection.
ODBC DSN
An ODBC DSN holds the following information to configure an ODBC driver for use.
- Database Information
- UserID
- Password
- Connection Information
- 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. It can be stored on a workstation but can also be placed in a shared directory in a network location.
A User or System DSN is recommended for consistent performance when using ODBC, see Access SQL-Database via ODBC driver in Leapwork.
For clarification, contact our Priority Support.