UniDAC 5.5.11 Problem

itSDS · 2014-09-30 09:24:53

Hi ab,

i updated to UniDAC 5.5.11 yesterday and get an Error Message Connecting to MySQL.
In UniDAC there is a new Validation Function which checks the SpecificOptions if you add / modify any.

Server and Port is no valid Option for this.

so i Modified SynDBUniDAC.pas a little

constructor TSQLDBUniDACConnection.Create(aProperties: TSQLDBConnectionProperties);
var options: TStrings;
    PortNumber : Integer;
begin
  inherited Create(aProperties);
  fDatabase := TUniConnection.Create(nil);
  fDatabase.ProviderName := UTF8ToString(fProperties.ServerName);
  case aProperties.DBMS of
  dSQLite, dFirebird, dPostgreSQL, dMySQL, dDB2:
    fDatabase.Database := UTF8ToString(fProperties.DatabaseName);
  else
    fDatabase.Server := UTF8ToString(fProperties.DatabaseName);
  end;
  options := (fProperties as TSQLDBUniDACConnectionProperties).fSpecificOptions;
  if fDatabase.Server='' then // see TSQLDBUniDACConnectionProperties.URI()
    fDatabase.Server := options.Values['Server'];
  if fDatabase.Database='' then
    fDatabase.Database := options.Values['Database'];
  if (fDatabase.Port=0) and TryStrToInt(options.Values['Port'], PortNumber) then
    fDatabase.Port := PortNumber;
  fDatabase.Username := UTF8ToString(fProperties.UserID);
  fDatabase.Password := UTF8ToString(fProperties.PassWord);
// BUGFIX s.d. UniDAC 5.5.11 Überprüft ungültige Parameter
//  fDatabase.SpecificOptions.AddStrings(options);
end;

I removed the last line cause Server and Port where the only Options.

Pls Check if there could be any unknown consequences i did not see.

ab · 2014-09-30 10:27:53

Does http://synopse.info/fossil/info/07db9ce72a works as expected now?

itSDS · 2014-09-30 13:56:25

Just tested it and it works.

mORMot Open Source

#1 2014-09-30 09:24:53

UniDAC 5.5.11 Problem

#2 2014-09-30 10:27:53

Re: UniDAC 5.5.11 Problem

#3 2014-09-30 13:56:25

Re: UniDAC 5.5.11 Problem

Board footer