Difference between revisions of "Manage DSN"

Revision as of 08:15, 20 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.

      i.  Click on the "Add" button. A Create popup window will become active on the right hand side.

     ii.  Enter your Data Source Prefix (required).

    iii.  Choose a database type from the drop-down menu.

    iv.  Choose a langauge: ASP or ASP.NET. form the drop-down menu.

    v.  Select an .mdb file from the database drop-down menu (required).

    vi. Click "Apply" to create new data source name

        Click" Cancel" to dismiss all changes.

To Upload a database:

1. Click "Browse" in order to locate your file that you wish to upload.

2. Click "Upload" 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.