Adding or Deleting an ODBC Data Source

You need to add an ODBC data source to connect your ODBC client to Microsoft® SQL Server™. You can use the ODBC Data Source Administrator in Control Panel and the Microsoft 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,
• Call SQLConfigDataSource with the fRequest parameter set to either SQL_REMOVE_DSN or SQL_REMOVE_SYS_DSN.
• Delete file data sources by deleting the file containing the data source.

To add an data source

To delete a data source

See Also