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
- In Windows Explorer, select the Microsoft Data Link file.
- Click Delete, and then click Yes to confirm the deletion.
Deleting an ODBC Data Source
To delete a data source by using ODBC Administrator
- On the Start menu, point to Settings, and then click Control Panel.
- 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.
- Click the data source to delete, click Remove, and then click Yes to confirm the deletion.