Jdbc dsn

---

---

How to Set Data Source Name in Jdbc

DSN (Data Source Name) is a file which stores a database name. An ODBC driver uses a DSN file and reads a database name then connects with that database.

Tpyes of DSN

1. System DSN
2. User DSN
3. File DSN

System DSN: System DSN will be stored in a shareable location of registry and this type of DSN is accessible for multiple user accounts of the system.

User DSN: User DSN will be stored in a non-shareable location of registry and this type of DSN is only accessible for one user account of the system.

File DSN: File DSN is like user DSN, but the DSN will be stored in a user given location of hard disk.

---

---