Adding or Deleting an ODBC Data Source
You must add an ODBC data source to connect your ODBC client to an instance of Microsoft® SQL Server™. You can use the ODBC Data Source Administrator in Control Panel and the SQL Server DSN Configuration Wizard to accomplish this. You can also add a data source programmatically using one of several ODBC API functions; however, these methods are recommended only for advanced users.
ODBC data sources can be deleted in several ways:
- Using the ODBC Data Source Administrator utility in Control Panel,
- Calling SQLConfigDataSource with the fRequest parameter set to either SQL_REMOVE_DSN or SQL_REMOVE_SYS_DSN.
- Deleting the file containing the data source.
To add a data source