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