This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
dev:sql:statements:connect:home [2010/07/04 04:02] tdo |
dev:sql:statements:connect:home [2010/07/29 20:40] tdo |
||
|---|---|---|---|
| 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 the 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 ==== | ||