Help Center

Version 2.0

• Email Support: Submit a Ticket

• Windows Hosting
• Working with Databases

Help Center Search

Related Articles

• Connecting to a Microsoft SQL Server Database Using ASP/ADO
• Connecting to a MySQL Database Using ASP/ADO
• What MySQL Server Features are Disabled on my Shared Hosting Account?
• Do you restrict any features in MySQL 4.1/5.0?
• What is MARS and how do I use it?
• What are the major differences between MySQL 4.0 and 4.1/5.0?
• Is there a size limit on MS SQL databases?

What is a File DSN?

The purpose of the Windows file DSN (data source name) is to centrally store your database connection information. If you have many Web pages that require database access, this feature enables you to simply reference the path of the file DSN instead of having to provide the database connection details on every page.

For security reasons, the file DSN is kept in a sub-directory of your hosting content directory that cannot be viewed. The file DSN works with ASP and uses ADO to access a database. This directory is named "_dsn" and you can find it at the root of your hosting account.

NOTE: If you use file DSNs with a Linux shared hosting account, they work only with MySQL databases and must connect to a ColdFusion Web site.

• Not helpful
• Somewhat helpful
• Helpful
• Very helpful
• Solved my problem