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.
An ODBC DSN holds the following information to configure an ODBC driver for use.
- Database Information
- 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.
What is recommended?
A User or System DSN is recommended for consistent performance when using ODBC.
To learn how to Access SQL-Database via ODBC driver in Leapwork, click here
For clarification, please contact our Priority Support.