How To Delete ODBC Data Source Using SqlConfigDataSource

MORE INFORMATION

The following sample code demonstrates how to use this API function to remove a Visual FoxPro Database datasource. To use this code, you need to create a datasource called rmtest that points to the data1.dbc in your local hard drive.

   DECLARE Integer SQLConfigDataSource IN odbccp32.dll Integer, ;
      Integer, String, String
   DriverName="Microsoft Visual FoxPro Driver"
   IsRemove =SQLConfigDataSource(1,3,DriverName, "DSN=rmtest" + CHR(0)+;
               "Description=david test"+CHR(0)+;
               "SourceDB=C:\TEMP\data1.dbc"+CHR(0)+;
               "SourceType=DBC")
   IF IsRemove>0
      WAIT WINDOW "Deleted"
   ELSE
      WAIT WINDOW "Delete failed"
   ENDIF
				

Note that the "Description=david test" portion of the connection string can be omitted and the datasource will still be removed.