This is an old revision of the document!


DRAFT

OdxSQL Connect

Description

CONNECT establishes a connection to an Omnidex Environment and opens a cursor.

Enter CONNECT followed by the environment catalog file spec and any desired parameters at the prompt.

Syntax

 CONNECT [TO] Omnidex_Environment 
     [ON host[:port]] 
     [AS [user]/[password]]
     [USING api] 
     [WITH options]
Omnidex Environment
[ON host[:port]]
[AS [user]/[password]]

Specify a username and password in the AS [ user]/[ password] clause.

[USING api]
  • ODBC
  • JDBC
  • CLOA
  • OA - OmniAccess - this is the default if no USING clause is specified.
[WITH options]

Specify connect options in the WITH clause.

The NOCURSOR option, will cause a connection to be established without opening a cursor.

Examples

>connect orders.env
Connected to C:\Omnidex\Demodata\orders.env
 
Back to top
programs/odxsql/commands/connect.1259764451.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)