Test a Connection

To test a connection, click "Connect" from the Edit Data Source window. DSEDIT will establish two connections to the Omnidex Environment Catalog, one through the Omnidex Client Omnidex Access API (CLOA) and one through the Omnidex ODBC Gateway Interface.

When the connections are successfully established, you are given four options to choose from:

• Info - See database info
• Query - Query the indexes
• SQL - Execute a SQL statement
• Disconnect - Terminate both connections

Info

Info displays structural information about the connected environment. This includes tables and columns, native indexes, Omnidex MDK and ASK indexes, and parent child relationships as defined in the Omnidex Environment Catalog. This information is obtained through the CLOA connection.

Query

Query allows you to pass criteria to columns installed with Omnidex indexes to test the indexes through the CLOA connection.

First you are prompted to choose a table to query. (Joins are not allowed in this test.)

Next, a list of indexed columns and input text boxes is displayed, allowing you to enter criteria for one or more column. The qualified records are retrieved and displayed in the grid at the bottom of the screen.

ODBC SYSTEM Data Source for Windows ODBC applications

SQL allows you to directly enter and execute SQL statements to test the ODBC connection. The qualified records are retrieved and displayed in the grid at the bottom of the screen.

Disconnect

Disconnect terminates both connections and returns you to the previous window.

Top