Page 1 of 1
Creating a CDX table in an ADS data dictionary in XBASE++
Posted: Fri Sep 13, 2019 10:00 am
by Tim K
I want to create tables on the fly into a Data dictionary in my app so I don't have to manually create 6 tables every time I add a table. I've tried DBCREATE( ) using the dictionary dacsession but it creates it in the default free table session. I'm trying a CREATE TABLE ...IN DATABASE SQL statement but it's erroring saying the user doesn't have rights, even though the dictionary setting is unrestricted. Is there a way to do this?
Re: Creating a CDX table in an ADS data dictionary in XBASE+
Posted: Fri Sep 13, 2019 12:31 pm
by rdonnay
Have you tried making your dictionary user ID AdsSys?
Re: Creating a CDX table in an ADS data dictionary in XBASE+
Posted: Fri Sep 13, 2019 1:31 pm
by Tim K
I will give it a try.
Re: Creating a CDX table in an ADS data dictionary in XBASE+
Posted: Fri Sep 13, 2019 3:11 pm
by Tim K
USER() is 'anonymous.' I added ";user ID = adssys" to my DacSession() connection string. Still comes back 'anonymous.'
I probably can't address this further until Monday.
Re: Creating a CDX table in an ADS data dictionary in XBASE+
Posted: Sat Sep 14, 2019 8:46 am
by rdonnay
Skype me on Monday.
Re: Creating a CDX table in an ADS data dictionary in XBASE+
Posted: Tue Sep 17, 2019 11:27 am
by Tim K
It was syntax in my connection string. ";UID=AdsSys" did the trick. I can now create a table in the dictionary. Thanks, Roger.