• Article

Adding or Deleting an ODBC Data Source

You must add an Open Database Connectivity (ODBC) data source to connect your ODBC client to an instance of Microsoft SQL Server. To add a data source, you can use ODBC Data Source Administrator, launched by clicking Data Sources (ODBC) under Administrative Tools in Control Panel, and the SQL Server DSN Configuration Wizard. You can also add a data source programmatically using one of several ODBC API functions; however, these methods are recommended only for advanced users.

There are several ways to delete an ODBC data sources:

  • By using ODBC Data Source Administrator.

  • By calling SQLConfigDataSource with the fRequest parameter set to either SQL_REMOVE_DSN or SQL_REMOVE_SYS_DSN.

  • By deleting the file containing the data source.

To add a data source

Configuring ODBC Data Sources.

To delete a data source

Configuring ODBC Data Sources.