Active Server Pages Support


ODBC/DSN

At a customers request, and a hosting plan supporting ODBC/DSN, Frontpage sets up an ODBC System DSN (data source name) which points to a Microsoft Access database within their site. The data source name is a textual string that is used to reference the data source by application programs, such as Microsoft Access. A unique identifier must be provided for each data source, such as xyzdatabase noted below.

In other words, the data source name allows you to interface with a Microsoft Access database using ASP The database is placed in a data directory outside of the content directory for security purposes. If visitors to the site will be allowed to make modifications to the database, our Frontpage technicians need to know so they can assign write permissions on that folder where the database resides.

For example, you have a database called mydatabase1.mdb and it is located in a folder called mydatafolder. You select any name for the DSN, such as xyzdatabase, and contact our tech department and tell them: "I would like a DSN of xyzdatabase for mydatabase1.mdb located in mydatafolder." Also, be sure to inform our tech department if you need write permissions for people to modify the database.

You will then use the DSN as part of your connection string when creating ASP pages that need to connect to the database. See our listing of ASP Web Sites.


ASP Web Sites

Learn about ASP, find useful ASP scripts for your site and create a dynamic web site.