I am trying to add fields to a table in a data dictionary. I have a query with the SQL = Alter table PrintClasses add column SortType integer Then I run Query->ExecSQL(); I get an error "The command cannot be completed with the current user permissions" Error 5054 I can do this on free tables with no error. I have Windows 7. How do I set the permissions of the data dictionary so I can add fields? Thanks! |
you need to connect using ADSSYS user or any other user either member of DB:ADMIN or with the permissions to modify the table. Thank you for the help. I'm just running Local Server, so I'm not familiar with ADSSYS for connecting. If that a function of the AdsConnection component? I don't have a connection password, maybe I need one.
(11 Feb '16, 01:14)
Davi in Wisc...
AdsConnection1.UserName := 'ADSSYS'; AdsConnection1.Connect;
(11 Feb '16, 01:50)
Joachim Duerr
I have the TAdsConnection component on a form. I have Username set to AdsSys, and Password is set to 'Password' in the object inspector. My TAdsDictionary has Username and Password set to the same values. In my code I have AdsConnectionDict->Username = "AdsSys"; AdsConnectionDict->Password = "Password"; AdsConnectionDict->IsConnected = true; I get a 7078 error when I try to connect. I'm not sure if I have to set the password through ARC32.
(13 Feb '16, 23:07)
Davi in Wisc...
|