whats new ¦  programming tips ¦  indy articles ¦  intraweb articles ¦  informations ¦  links ¦  interviews
 misc ¦  tutorials ¦  Add&Win Game

Tips (1541)

Database (90)
Files (137)
Forms (107)
Graphic (114)
IDE (21)
Indy (5)
Internet / LAN (130)
IntraWeb (0)
Math (76)
Misc (126)
Multimedia (45)
Objects/
ActiveX (51)

OpenTools API (3)
Printing (35)
Strings (83)
System (266)
VCL (242)

Top15

Tips sort by
component


Search Tip

Add new Tip

Add&Win Game

Advertising

24 Visitors Online


 
...get the ODBC datasource names?
Autor: Grinder
[ Print tip ]  

Tip Rating (3):  
     


uses
  
Registry;

procedure TForm1.GetDataSourceNames(System: Boolean);
var
  
reg: TRegistry;
begin
  
ListBox1.Items.Clear;

  reg := TRegistry.Create;
  try
    if 
System then
      
reg.RootKey := HKEY_LOCAL_MACHINE
    else
      
reg.RootKey := HKEY_CURRENT_USER;

    if reg.OpenKey('\Software\ODBC\ODBC.INI\ODBC Data Sources', False) then
    begin
      
reg.GetValueNames(ListBox1.Items);
    end;

  finally
    
reg.CloseKey;
    FreeAndNil(reg);
  end;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
  
//System DSNs
  
GetDataSourceNames(True);

  //User DSNs
  
GetDataSourceNames(False);
end;

 

Rate this tip:

poor
very good


Copyright © by SwissDelphiCenter.ch
All trademarks are the sole property of their respective owners