Deleting a Data Source

ADO and SQL Server

ADO and SQL Server

Deleting a Data Source

Data sources can be deleted by:

  • Deleting the .udl file if the data source is a Microsoft Data Link.

  • Using ODBC Administrator if the data source is an ODBC data source.
Deleting a Microsoft Data Link

To delete a Microsoft Data Link file by using Windows Explorer

  1. In Windows Explorer, select the Microsoft Data Link file.

  2. Click Delete, and then click Yes to confirm the deletion.
Deleting an ODBC Data Source

To delete a data source by using ODBC Administrator

  1. On the Start menu, point to Settings, and then click Control Panel.

  2. Double-click ODBC Data Sources (32bit) (if using Windows 95 or Windows 98) or Data Sources (ODBC) (if using Windows NT 4.0 or Windows 2000), and then click the User DSN, System DSN, or File DSN tab.

  3. Click the data source to delete, click Remove, and then click Yes to confirm the deletion.