Recently, a customer reported a problem with our application, which is running against sqla12. The windows system and application event logs, and the sqla console window, provided nothing helpful.
Is there a way to setup sqla so that it...
asked 10 Jan '12, 10:03
SQL Anywhere does not (yet) support setting an error log level but it does do your other two requests. See the documentation for the -o switch (to specify the name of the console log messages file) and the -os switch (to limit size of the console log file) .
answered 10 Jan '12, 13:16
Just to add to Mark's answer:
AFAIK there's no "general error logging facility" in SQL Anywhere. And I would conclude that it's difficult to create a general one, simply since the need for error handling is usually application-specific, i.e. the requirements will be quite different between a "closed app" used by ordinary users (as in your case, methinks) and, say, a tool to query a database ad-hoc. In the former case, it would be useful to install error handling code to log the errors/warnings (possibly with the help of MESSAGE statements on the server-side) whereas in the latter case, you would possibly prefer immediate error message prompts instead of an error log...
Some more hints may be found in this FAQ.
answered 10 Jan '12, 14:45