checkk if SQL Sever is ready for client connection

[formi]

Hi

what is the best way to check if the SQLserver is ready to establish a connection from a client?

Thanks for your answer

Peter

[AndreyZ]

Hello,

The only way to check if SQL Server is available and allows connecting to it, is to make a connection attempt. Here is a code example:

Code: Select all

var
  con: TUniConnection;
begin
  con := TUniConnection.Create(nil);
  try
    try
      con.ProviderName := 'SQL Server';
      con.Server := 'server';
      con.Database := 'database';
      con.Username := 'username';
      con.Password := 'password';
      con.LoginPrompt := False;
      con.Open;
      ShowMessage('SQL Server is available');
    except
      on E: Exception do
        ShowMessage(E.Message);
    end;
  finally
    con.Free;
  end;
end;

[formi]

Thanks!

[AndreyZ]

Feel free to contact us if you have any further questions about UniDAC.