A DSN should at least include the following contents:
◆ Information about the database driver.
◆ Database storage location. The storage location of a file type database (such as Access) is the path of the database file; The storage location of non file databases (such as SQL Server) refers to the name of the server.
◆ Database name. In ODBC Data Source Manager, all DSN names cannot be duplicate. A DSN can be defined as any of the following three types:
★ User data source: This data source is local to the computer that created it, and can only be used by the user who created it.
★ System data source: This data source belongs to the computer that created it and belongs to this computer rather than the user who created it. Any user with appropriate permissions can access this data source.
★ File data source: This data source is determined for the underlying database file. In other words, this data source can be used by any user who has installed the appropriate driver. DSN file (data source name) Windows DSN file (data source name) is mainly used to store database connection information. If you have many web pages that need to transfer data, you can easily complete it through the DSN file path without transferring data to each page. For security reasons, DSN files are usually placed in a subdirectory of the host directory, so unknown visitors cannot access this directory. The DSN file needs to access the database together in ASP and ADO. The name is "_dsn" in the root directory of the host account (note: DSN files only support the windows scheme).
