Driver Mode connection

BIZ TMS Aurelius
1
i get the error  :   Incompatible Types : 'Integer' and 'String' 
when using params to set the parameters to connect to ms sql server using driver mode

AureliusConnection1.DriverName := 'MSSQL';
AureliusConnection1.Params['Server'] := 'localhost';

thanks, 
Ahmed
2

Hello,

Params is a TStrings object, thus you must use Values to add/access param values:



AureliusConnection1.DriverName := 'MSSQL';
AureliusConnection1.Params.Values['Server'] := 'localhost';
AureliusConnection1.Params.Values['Database'] := 'NORTHWND';
AureliusConnection1.Params.Values['TrustedConnection'] := 'True';

or simply add name=value pairs:



AureliusConnection1.DriverName := 'MSSQL';
AureliusConnection1.Params.Add('Server=.\SQLEXPRESS');

Documentation is indeed incorrect and misleading. We will fix that soon.