How do I setup a DSN (Windows) ?
A Data Source Name, or DSN, is how you reference your database in your ASP applications. The DSN describes important information about your database, including the path where it resides as well as the ODBC driver that should be used to access it.
Adding a DSN
The following information is needed to successfully create a System DSN for your database:
- Web Site Address
- DSN Name
- Database Name
- Database Type (ACCESS or SQL)
You should set the DSN name to something that will reflect which particular database you are configuring the DSN for. Please note that you will need to refer to your DSN in the format userid.[DSN Name] in your applications (where userid is your account's User ID). The database name is the path to the database on your site for Microsoft Access. For Microsoft SQL Server databases, enter your username as the database name. You will also need to specify what type of database you are using: Microsoft Access, or SQL Server.
|
Notes
- Remember that you must reference your DSN as userid.[DSN Name].
- Your database must be stored in the "data" directory of the site if you want to allow write access in your web applications. By default, in order to protect your databases, the /data directory is configured to deny all web requests.
|
print page
