How can I modify an existing Data Source Name (DSN) using the Aplus.Net Control Panel?

Answer by: Frederique Taillefer, Aplus.Net Knowledge Base Support.

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).

You can modify your MSSQL or MS Access Data Source Names using the DSN Manager tool available in the Aplus.Net Control Panel.

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.

Here’s how to modify an existing DSN using the Aplus.Net Control Panel:

Start by logging into the Aplus.Net Control Panel at http://cp.aplus.net using your Registration Number and Customer Password.
Select Web Hosting from the top navigation bar.
Next, select Hosted Domains and click on Manage Hosted Domains.
Now, select your domain name (NOTE: If your actual domain name does not yet resolve to Aplus.Net’s servers, you must use your utility domain (username.win.aplus.net) to manage your DSN).
Next, click on Manage DSN Records.
Select the DSN record that you’d like to modify from the Type / Names / Description drop-down menu.
Click the Modify button. A Create/Modify popup window will appear.
Modify the necessary information, then click Save.

Sample Connection Script:
You can use the Sample button to display two script examples of a DB connection: ASP and ASP.NET.

for MS Access - you can simply copy/paste and use the connection script.
for MS SQL - make sure you input your DB username and password at the designated places.