Kylix
Tips

NEW TIPS
Database (135)
Files (612)
Forms (606)
Graphic (536)
IDE (456)
Indy (433)
Internet / LAN (590)
IntraWeb (443)
Kylix (447)
Math (561)
Misc (591)
Multimedia (496)
Objects/
ActiveX (503)

OpenTools API (438)
Printing (459)
Strings (583)
System (721)
VCL (586)

Search Tip
Top15
Add new Tip

Forum

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

Tip Rating (0):  
     



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 © Torry's Delphi Pages Torry's Delphi Pages Maintained by Simon Grossenbacher Notes? Comments? Feel free to send... Copyright © 1996-2001