Foxhound 2.0 FAQ
Foxhound 2.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


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?


This page was last updated on December 3, 2011. Foxhound 2.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com