This is an old revision of the document!


DRAFT

Omnidex SQL: CONNECT

Description

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.

Syntax

CONNECT [TO] [ [host:port] ]env_filespec[ [node_name] ]
        [ON host[:port]] 
        [AS [user]/[password]]
        [USING < ODBC | JDBC | CLOA > ] 
        [WITH options]

Discussion

Environment_filespec

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]; 

ON host:port

Specifies that the Environment Catalog is located on a remote server and the Omnidex Network Services (OdxNet) will be used for access.

AS [user]/[password]

Used to specify a username and password if required by the underlying relational database.

connect odxoracle.xml as orauser/pass;

USING api

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;

WITH options

Options specific to the CONNECT command.

MAINTENANCE - Accesses the Omnidex Environment exclusively to facilitate changes.

connect to odx.xml with maintenance;
 
Back to top
dev/sql/statements/connect/home.1278179994.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)