E.2.4 Custom Connections using File DSNs

Users can create File DSNs that connect to ODBC data sources using the Microsoft ODBC Admin tool. Once the resulting *.dsn file is imported to the Web, FrontPage users can create a connection that points to it. Note that if you are using a file-based database such as dBase, your *.dsn file will contain a hard-coded file reference that may not work when moved to a different server.
The Connection String constructed by FrontPage would look like:
Application("Inventory_ConnectionString") = "File Name=URL=/Inventory_file_dsn.dsn"
A File DSN can be stored in protected directories available only to the Chili!Soft ASP server and the user that created it. The use of File DSNs is typically the most secure approach to providing database access on a shared Web server because the File DSN can contain the user name and password for the database, and when Chili!Soft ASP is running in Inherited User mode, it can only open the file containing the DSN if it is running as a user with permission to open the file.
Copyright © 2000 Chili!Soft
|