This is an old revision of the document!
A connection must be established to a specific Omnidex Environment before any Omnidex retrievals can be peformed.
For testing with OdxSQL the CONNECT command is used to establish a connection. A connection can be established to an Omnidex Environment, an ODBC datasource file, or a remote Omnidex environment using a connection string.
When using the Omnidex ODBC and Omnidex JDBC driver, connections are established using ODBC and JDBC calls.
CONNECT [TO] [ [host:port] ]environment_filespec[ [node_name] ] [ON host[:port]] [AS [user]/[password]] [USING < ODBC | JDBC | CLOA > ] [WITH options]
Specifies the Omnidex XML Environment containing the Omnidex metadata. The keyword TO is optional.
connect odx.xml;
A connection string enclosed in brackets can prefix the environment_filespec to specify a host and port.
connect [server1:7555]odx.xml;
A specific node can be specified to connect to a specific node.
connect odx.xml[node1];
Specifies that the Environment Catalog is located on a remote server and the Omnidex Network Services (OdxNet) will be used for access.
Used to specify a username and password if required by the underlying relational database.
connect odxoracle.xml as orauser/pass;
Used to specify the either the ODBC or JDBC api to use for access. This is primarily used to test ODBC and JDBC access using OdxSQL.
connect odx.xml using ODBC;
Options specific to the CONNECT command.
MAINTENANCE - Accesses the Omnidex Environment exclusively to facilitate changes.
connect to odx.xml with maintenance;