Differences

This shows you the differences between two versions of the page.

Link to this comparison view

dev:sql:statements:connect:home [2010/07/04 04:02]
tdo
dev:sql:statements:connect:home [2016/06/28 22:38] (current)
Line 11: Line 11:
 When using the Omnidex ODBC and Omnidex JDBC driver, connections are established using ODBC and JDBC calls.  When using the Omnidex ODBC and Omnidex JDBC driver, connections are established using ODBC and JDBC calls. 
 ===== Syntax ===== ===== Syntax =====
-  CONNECT [TO] [ [host:port] ]environment_filespec[ [node_name] ] +  CONNECT [TO] [ [connection_string] ]environment_filespec[ [node_name] ] 
-          [ON host[:port]]  +          [USING < ODBC | JDBC > ] 
-          [AS [user]/[password]] +
-          [USING < ODBC | JDBC | CLOA > ] +
           [WITH options]           [WITH options]
    
  
 ===== Discussion ===== ===== Discussion =====
 +==== TO ====
 +TO is optional and is only included for readability.
 +==== connection_string ====
 +//Connection_string// is a bracketed server name and optional port that directs the connection through the Omnidex Network services.
 +
 +When using a //connection_string// the USING <ODBC | JDBC > clause must be specified.
 +
 +  connect [server1:7555]odx.xml using ODBC;
 +
 +Under Windows, the //environment_filespec// must have the backslash directory separater escaped.
 +
 +  connect [server1:7555]c:\\dev\\odx\\myenv.xml using odbc
 +
 +
 ==== Environment_filespec ==== ==== Environment_filespec ====
-The Environment_filespec specifies the Omnidex XML Environment containing the Omnidex metadata.  The keyword TO is optional.+The //Environment_filespec// specifies the Omnidex XML Environment containing the Omnidex metadata.  The keyword TO is optional.
  
   connect odx.xml;   connect odx.xml;
Line 32: Line 44:
   connect odx.xml[node1];    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]  ==== ==== AS [user]/[password]  ====
  
Line 40: Line 50:
  
   connect odxoracle.xml as orauser/pass;   connect odxoracle.xml as orauser/pass;
- 
 ==== USING api  ==== ==== 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.+Used to specify either the ODBC or JDBC api to use for access.  This is primarily used to test ODBC and JDBC access using OdxSQL.  This clause must be specified if using a connection string. 
 + 
 +  connect [server1:7555]odx.xml using ODBC;
  
-  connect odx.xml using ODBC; 
 ==== WITH options  ==== ==== WITH options  ====
  
 
Back to top
dev/sql/statements/connect/home.1278216156.txt.gz · Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0