|
Question: How do I see the schema for adhoc reporting?
Answer:
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
Adhoc Schema - autostart and connect
and clicking Display Schema.
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;
DBF=C:\ProgramData\RisingRoad\Foxhound2\adhoc_schema1.db; AUTOSTART=YES;
See also...
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?
|