Question: How do I see the schema for adhoc reporting?
A separate empty database file adhoc_schema1.db is delivered with Foxhound, containing all the views and underlying
tables that are available for adhoc reporting.
You can view these tables and views by selecting this connection string on the String tab of the Foxhound menu
and clicking Display Schema.
Adhoc Schema - autostart and connect
For the record (and in case you delete that connection string), here's how to auto-start and connect to this database:
ENG=adhoc_schema1; DBN=adhoc_schema1; UID=DBA; PWD=sql; DRIVER=SQL Anywhere 12;
START=C:\Program Files\SQL Anywhere 12\Bin32\dbeng12.exe;
How do I run adhoc queries on the Foxhound database?
How do I see the schema for adhoc reporting?
How do I change the ADHOC password?