Creating a CDX table in an ADS data dictionary in XBASE++

Xbase++ 2.0 Build 554 or later
Post Reply
Message
Author
User avatar
Tim K
Posts: 51
Joined: Thu Jun 03, 2010 3:55 pm

Creating a CDX table in an ADS data dictionary in XBASE++

#1 Post 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?

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Creating a CDX table in an ADS data dictionary in XBASE+

#2 Post by rdonnay »

Have you tried making your dictionary user ID AdsSys?
The eXpress train is coming - and it has more cars.

User avatar
Tim K
Posts: 51
Joined: Thu Jun 03, 2010 3:55 pm

Re: Creating a CDX table in an ADS data dictionary in XBASE+

#3 Post by Tim K »

I will give it a try.

User avatar
Tim K
Posts: 51
Joined: Thu Jun 03, 2010 3:55 pm

Re: Creating a CDX table in an ADS data dictionary in XBASE+

#4 Post 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.

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Creating a CDX table in an ADS data dictionary in XBASE+

#5 Post by rdonnay »

Skype me on Monday.
The eXpress train is coming - and it has more cars.

User avatar
Tim K
Posts: 51
Joined: Thu Jun 03, 2010 3:55 pm

Re: Creating a CDX table in an ADS data dictionary in XBASE+

#6 Post 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.

Post Reply