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.