28 votes
command-line client like unixODBC isql (Linux, Windows)
Details (e.g., username, password, connection string) should be command-line parameters while SQL statements should come from stdin. That way I could either use it with a command-line prompt or redirect into it from .sql text files with scripts.
joachimd
I fixed it in the meantime. And since ADS servers are backwards compatible to older clients, it should work in future.
actual source and executable can be downloaded from http://www.jd-engineering.de/ads/adsconsole.zip
PRosario
adsconsole is not supported by Advantage. I don't want to invest time to craft scripts to work with a tool that may not work with future versions (a tool that Advantage is not committed to).
adsconsole does not work. It works with SELECT statements, but other statements raise an exception. The exception handler reruns the statements. Result: Error messages about duplicate objects.
joachimd
adsconsole runs on linux and windows. I've published the (Delphi, Kylix) source code somewhere in the newsgroups.
PRosario
1) Will it run on Linux? 2) Will Advantage support it? 3) Is it open source?
leiwering
please take a look at the AdsCmd at www.ads-toolbox.com.
It currently does not support user/password input, but I could add that if you like it.