This is an old revision of the document!
CONNECT establishes a connection to an Omnidex Environment. Before any Omnidex operations can be performed on an Omindex enhanced data store, a connection must be established.
Note that when using the Omnidex ODBC and Omnidex JDBC driver, connections are established using ODBC and JDBC calls.
The Omnidex CONNECT Statement is primarily used within OdxSQL.
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 be used 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;