Delete a Data Source (ODBC)


Updated: August 1, 2016

System_CAPS_ICON_warning.jpg Warning

SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. Avoid using SNAC in new development work, and plan to modify applications that currently use it. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database.

You can delete a data source by using ODBC Administrator, programmatically (by using SQLConfigDataSource), or by deleting a file (if a file data source name).

To delete a data source by using ODBC Administrator

  1. In Control Panel, open Administrative Tools, and then double-click either ODBC Data Sources (64-bit) or ODBC Data Sources (32-bit). Alternatively, you can run odbcad32.exe from the command prompt.

  2. Click the User DSN, System DSN, or File DSN tab.

  3. Select the data source to delete.

  4. Click Remove, and then confirm the deletion.

To programmatically delete a data source, call SQLConfigDataSource using either ODBC_REMOVE_DSN or ODBC_REMOVE_SYS_DSN as the second parameter.

The following sample shows how you can programmatically delete a data source.

// remove_odbc_data_source.cpp  
// compile with: ODBCCP32.lib user32.lib  
#include <iostream>  
#include <windows.h>  
#include <odbcinst.h>  
int main() {   
   LPCSTR provider = "SQL Server";   // Windows SQL Server Driver  
   LPCSTR provider = "SQL Server";   // Windows SQL Server driver  
   LPCSTR provider2 = "SQL Server Native Client 11.0";   // SQL Server 2012 Native Client driver  
   LPCSTR dsnname = "DSN=data2";  
   BOOL retval = SQLConfigDataSource(NULL, ODBC_REMOVE_DSN, provider, dsnname);  
   std::cout << retval;   // 1 if successful  

Configuring the SQL Server ODBC Driver How-to Topics

Community Additions