Difference between revisions of "Manage DSN"
From Help
| Line 1: | Line 1: | ||
| + | =Overview= | ||
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). | 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). | ||
| Line 5: | Line 6: | ||
<br> | <br> | ||
| − | + | =Create a DSN Record= | |
| − | |||
| − | |||
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. | 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. | ||
| − | + | #Click on the '''Add''' button. A Create popup window will become active on the right hand side. | |
| − | |||
| − | #Click on the | ||
#Enter your Data Source Prefix (required). | #Enter your Data Source Prefix (required). | ||
#Select a database type from the drop-down menu. | #Select a database type from the drop-down menu. | ||
#Select a language:ASP or ASP.NET. from the drop-down menu. | #Select a language:ASP or ASP.NET. from the drop-down menu. | ||
#Select an .mdb file from the database drop-down menu (required). | #Select an .mdb file from the database drop-down menu (required). | ||
| − | #Click on the | + | #Click on the '''Apply''' button to create new data source name. |
| − | #Click on the | + | #Click on the '''Cancel''' button to dismiss all changes. |
<br> | <br> | ||
| − | + | =To Upload a Database= | |
| − | #Click on the | + | #Click on the '''Browse''' button in order to locate your file that you wish to upload.<br> |
| − | #Click on the | + | #Click on the '''Upload''' button to upload the file.<br> |
| − | |||
| − | <br> | ||
| − | + | =Delete a DSN= | |
#From the Available Data Source Names list, select the DSN you wish to delete.<br> | #From the Available Data Source Names list, select the DSN you wish to delete.<br> | ||
| − | #Click on the | + | #Click on the '''Remove''' button. |
[[Category:Setup]] | [[Category:Setup]] | ||
Latest revision as of 10:03, 29 March 2012
Overview
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.
Create a DSN Record
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.
- Click on the Add button. A Create popup window will become active on the right hand side.
- Enter your Data Source Prefix (required).
- Select a database type from the drop-down menu.
- Select a language:ASP or ASP.NET. from the drop-down menu.
- Select an .mdb file from the database drop-down menu (required).
- Click on the Apply button to create new data source name.
- Click on the Cancel button to dismiss all changes.
To Upload a Database
- Click on the Browse button in order to locate your file that you wish to upload.
- Click on the Upload button to upload the file.
Delete a DSN
- From the Available Data Source Names list, select the DSN you wish to delete.
- Click on the Remove button.