DelphiFAQ Home Search:

List of all ALIASES pointing to a SQL server

 

commentsThis article has not been rated yet. After reading, feel free to leave comments and rate it.

For a little tool, I recently needed to get a list of all aliases which point to a SQL db. (I did not want to see those Paradox files).

I came up with the following procedure, which I call like this:

GetAliases (ComboBox1.Items)

procedure GetAliases (const AList: TStrings);
var
  i    : Integer;
  Desc : DBDesc;
  Buff : Array [0..254] Of char;
begin 
  // list all BDE aliases 
  Session.GetAliasNames (AList); 
  for i := AList.Count - 1 downto 0 do 
  begin 
    StrPCopy (Buff, AList[i]); 
    Check (DbiGetDatabaseDesc (Buff, @Desc)); 
    // no Paradox, please
    if StrPas (Desc.szDBType) = 'STANDARD' then 
      AList.Delete (i)
  end
end; 

Comments:

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: