Difference between revisions of "Manage DSN"

Revision as of 08:05, 21 September 2011

Data Source Names are textual strings used by application programs to reference data sources. ODBC data sources store information about how to connect to the indicated data provider (i.e. Microsoft SQL database).

NOTE: You must provide a unique identifier for each data source. In other words, the name that you select for your DSN (Data Source Name) must be unique. It may take up to one hour for changes to take effect.

Here’s how to create a DSN using the  Manage DSN Records application:

You can create MSSQL, MySQL or MS Access Data Source Names using this tool however, before doing so you will need to upload the MS Access file to the server.

1. Click on the "Add" button. A Create popup window will become active on the right hand side.
   
2. Enter your Data Source Prefix (required).
   
3. Choose a database type from the drop-down menu.
4. Choose a language:ASP or ASP.NET. from the drop-down menu.
5. Select an .mdb file from the database drop-down menu (required).
   
6. Click the "Apply" button to create new data source name.
7. Click the "Cancel" button to dismiss all changes.

To Upload a database:

1. Click the "Browse" button in order to locate your file that you wish to upload.
   
2. Click the "Upload" button to upload the file.
   

Here’s how to delete a DSN :

1. From the Available Data Source Names list, select the DSN you wish to delete.
   
2. Click the "Remove" button.