Connect to ESP using the Linux ODBC Driver

Allows you to access ESP content by connecting to ESP using Linux ODBC.

1. Set LD_LIBRARY_PATH to <unixODBC2.3>/lib:$ESP_HOME/odbc
2. Set the environment variable PATH to <unixODBC2.3>/bin
3. Configure a data source name (DSN) by defining the DSN parameters:

   DSN Parameters

   Property	Description
   Servername	Property ID: Servername Type: string (Required) Cluster host name.
   Driver	Property ID: Driver Type: string (Required) Path to the ESP ODBC Driver.
   Port	Property ID: Port Type: integer (Required) Cluster port.
   Database	Property ID: Database Type: string (Required) String specifying project and authentication. For example, ws1/project1/user ws1/project1/rsa/<rsakeyfile> ws1/project1/krb
   Username	Property ID: Username Type: string (Required) Cluster login user.
   Password	Property ID: Password Type: string (Required) Cluster login password.
   SSLMode	Property ID: SSLMode Type: Enum 'enable | disable' (Optional) Cluster SSL Mode.

4. Start an ESP project and enter some data in the project stream or window.
5. Use isql or iusql (for Unicode) to run an SQL statement to extract the data from ESP. For example, here Trades is a stream or window in the ESP project that you started:

   isql -v myesp

   Sql > select * from Trades

   Now you can access and read data from an ESP project running on a Linux machine.