Deleting DSNs
The procedures in this section do not delete Data Dictionary Files (DDFs) or data files.
By default, when you delete a database in the PSQL Control Center, the associated DSN entries are removed simultaneously.
►
To toggle automatic removal of DSN entries when deleting a database in PCC
1
On the PCC Window menu, click Preferences. Expand the PSQL node if it is not already expanded.
2
Click General.
3
Clear the option Always remove associated DSN entries and click OK.
When you delete a database in PCC, you will be prompted by the Confirm DSN Removal dialog before deleting it.
You can clear those DSNs that you do not want to delete.
4
You can turn on automatic removal of DSN entries at anytime by selecting Always remove associated DSN entries in:
•
Confirm DSN Removal dialog
•
General screen of the Preferences dialog.
►
To Delete a DSN using ODBC Administrator (Windows platforms only)
1
In PCC, click Tools and select ODBC Administrator.
2
In the ODBC Administrator window, click the System DSN tab.
3
Select the DSN you wish to remove, and click Remove
You are prompted to confirm removal of the DSN.
4
Click Yes.
5
After the DSN has been removed, click OK to exit ODBC Administrator.
If you are simply deleting an unwanted DSN, you are finished. If you need to re-create the DSN, you should refer to one or more of the following sections:
If you need to do this
Refer to this section
Re-create an Engine DSN on a Server engine or a Workgroup engine
One of:
•
Setting Up Database Access on Windows
•
Setting Up Database Access on a Linux or OS X Server
Re-create a Client DSN on a client workstation
Setting Up Client Access from a Windows Client