HTML5ODBCExplorerSampleProg ODBC Explorer: A Sample HTML5 Program ODBC Explorer: A Sample HTML5 Program The ODBC Explorer is a simple iSQL-like sample HTML5 program which allows connection to any browser-local ODBC DSN (Data Source Name).Once connected, a list of available database catalogs is displayed, and users can easily explore the database schema and/or execute queries against it. Setup Prerequisite: Install and configure the HTML5 WebDB-to-ODBC Bridge. You can run the ODBC Explorer immediately, by loading it from our hosted copy; or download a zip file containing all source files, allowing local use or hosting on your own Web server. Make sure you have an ODBC DSN configured, or configure one now. In the example below, we'll connect to the publicly-accessible demo instance of Virtuoso -- host demo.openlinksw.com port 1111 username demo password demo Usage Load the ODBC Explorer sample program in your web browser. Choose your desired ODBC DSN from the drop down list box, enter username and password (if needed), and click the connect button.
Upon successful connection, a list of available DbCatalogs (as in the 3-part identification of database objects -- DbCatalog.Owner.Table) will be listed in the left frame.
Drill down into a DbCatalog (e.g., Demo) to see the Owner(s) (e.g., demo), and Object(s) therein.
Double-click an Object (e.g., Countries) to get a quick and easy look at its Structure
Indexes
Foreign Keys
References (i.e., the Foreign Key inverse)
When you drill into an object, the "Execute SQL" tab will be pre-populated with a default query -- SELECT * FROM <object>
You can edit this, or just click on the "Run SQL" button to execute.
SPARQL queries can also be executed with clickable anchor links generated for URIs.
Related Links HTML5 ODBC Bridge Installation and Configuration Web SQL Database API Spec OpenLink Virtuoso Website Platform-Independent iODBC Project Home Page Using WebID for Virtuoso ODBC login