when I create the following:
Code: Select all
dbCon := TMSConnection.Create(NIL);
dbCon.DataBase := sDIC;
dbCon.LoginPrompt := FALSE;
dbCon.Password := 'abc2018#';
dbCon.Username := 'DDM-User';
dbCon.Server := msSQL_SRV;
dbCon.Name := 'DBmR' + IntToStr(DBmRNum);
Code: Select all
dbPerso := TMSTable.Create(NIL);
Connection := dbCon;
dbPerso.Filtered := FALSE;
dbPerso.Name := 'PERSO' + IntToStr(DBmRNum);
dbPerso.TableName := 'PERSO';
dbPerso.KeyFields := 'PERS_ID';
Using Delphi XE7 and the latest SDAC and MS SQL Server 2017
Thanks!