bb.donnay-software.com

It was syntax in my connection string. ";UID=AdsSys" did the trick. I can now create a table in the dictionary. Thanks, Roger.

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.

I will give it a try.

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...

This is to be used across WAN connections. I've been quoted $3200 from an SAP rep for all my servers with a total of 220 user licenses. Thanks for looking into this.

I'm hoping for the benefit of some experience with ADS replication. Does it work like magic? Is it finicky? I have many replica databases I maintain. If this works well it could save me a lot of trouble.

That's what I was missing. Thanks.

I'm using a query using DC_AdsStatement that does a SELECT INTO a file which works great except the files selected from and created remain open, but not as open work areas. How do I release these files? Is DROP TABLE the proper way or is will that restrict future use?

Good information. Thank you.

I've noticed the architect's SQL query tool has a progress bar during queries. Is there a way to get progress data during dc_AdsStatement :execute() ?