Creating System DSNs
	What's New in IT IT Consulting Phones/VoIP Internet Security About Us Home

	Web Site Hosting	Web Design	Broadband/Access	E-Mail Solutions	Accept Credit Cards	Hosting Support

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.  

Creating a System Data Source Name for a database is an easy task with the ODBC Control Panel.  It is accessible through the "Database Tools" link in the Control Panel. Remember that you must reference your DSN as userid.[DSN Name].

• Adding a DSN
• Modifying or deleting a DSN
• Securing your data (important!)

Adding a DSN

The following information is needed to successfully create a System DSN for your database:

• DSN Name
• Database Name
• Database Type

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 and Microsoft FoxPro databases.  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, Microsoft FoxPro, or SQL Server.

The first thing you will see in the Database Tools control panel is the ODBC Data Sources list.  From here you can see information about the System DSNs that have already been created and add new System DSNs.  To create a new DSN, click on the "Add New Data Source" button.

Now you will see the Data Sources form.  This where you can enter all the information required to configure your DSN.  If you wanted to create a DSN called "myDB" for an Access database called "my.mdb" residing in the "data" directory of your site, you would fill out the form as illustrated below.

Clicking on the "Insert" button will add the DSN to the server and you will be taken to the "Feedback" form.  Here you can review the the configuration for the DSN you just set up.  You will also have the option of creating another new DSN or going back to the ODBC Data Sources List.

Modifying or Deleting a DSN

If you have already created a DSN, you will have the option of changing the database name or deleting the DSN altogether.  From the ODBC Data Sources list, you can select an individual DSN by clicking on it's number.

Now you will be able to change the name of the database in the in the textbox.   The change will be made on the server upon clicking the "Update" button.   You can also delete the DSN by clicking the "Delete" button.

Securing Your Data

• Your non-SQL database must be stored in the "data" directory of the site if you want to allow write access in your web applications.
• Warning! The /data directory is configured to allow all web requests by default!

In order to protect your databases, you must configure the /data directory to deny read requests. To do this:

• Enter Web Sites
• Click the site to modify
• Click Directory Permissions
• Click the Set Additional Directories button
• Select a directory
• Uncheck Allow Read Access
• Click Save

Please note: the information on this page applies to ITS web hosting plans. It may or may not apply to other environments. If you are looking for a feature described here, or better support from your hosting provider, please consider hosting your site with ITS!

Copyright © 1996-2024, Integrated Technical Solutions, Inc., all rights reserved. See Terms/Legal for trademarks, copyright, and terms of use.