I was introduced recently to the Advantage Database technology, and I now have to use it to interface with a legacy software on Win 7. I have successfully followed the advantagezone development help files in order to install both the ADS and the ODBC driver. A few questions remain, the first of which being the following: How does one change the password of a user/add a user?
I was unable to find any documentation regarding this matter. Could you point me to the relevant documentation or provide me with the command necessary to do so via command line?
Also I was wondering if there were any sort of GUI to manage the ADS, like MySQL has with PHPMyAdmin or the MySQL workbench.
Thanks for your help!
Advantage Database Server (ADS) uses a somewhat strange concept they've confusingly called a Data Dictionary (DD), which when used as designed controls users, rights, security, and access similar to what most DBMSs offer in the database itself.
Basically the only way to work with the ADS DD is through their GUI, known as the Advantage Data Architect (ARC32), which is available for download from the ADS Developer Zone. (You can do it via code, but for the types of things a DBA would do it's much easier to do things via ARC32.) Using it, you can create most of the types of things you'd typically use in a DBMS.
ARC32 also allows you to design your tables and indexes, as well as running SQL DDL and DML statements. The supported SQL grammar is also available in the documentation and covered in the book mentioned below.
You can find the documentation in ARC32 itself (using the Help menu or the ? on the toolbar), or via their Online Help FIles. The best place to start is in the topic The Advantage Developer's Guide, which is actually the entire contents of the book Advantage Database Server: A Developer's Guide. The book contains pretty good documentation on all of the aspects of both ARC32 and ADS itself, including use of the DD. Part 1, Chapter 4 has an entire section on adding users.