DSN (Data Source Name)

DSN

(Data Source Name)

Download PDF File


Connecting to Database use DSN to save used information to create connection to a[n database. In DSN on file [of] name ODBC driver to be used, name of computer taken as data center ( if we work with client server engine be like SQL server or Oracle), name or path from a database, timeout from connecting, and others

Through ODBC Driver Manager, we can create some types from DSN, that is:

  1. User DSN

DSN the on filename in system registry, and only can use by user in this time.

  1. System DSN

DSN kept in registry but DSN can use by all user.

  1. File DSN

DSN kept in file with file extension .dsn. file DSN can be copied easily to other computer. Therefore file DSN make the program installation phase become easier. The application we make have to know path from file DSN, therefore [at] program code, we have to provide path the intactness to file DSN., and we have to saving path the place for example in file INI.

Download PDF File

No comments: