Using unixODBC Driver Manager

Create a server using a unixODBC driver manager.

  1. Start the Create Server wizard. Enter:
    DCWizard.sh
  2. On the Welcome Create Server Wizard window, click Next.
  3. Select ECDA Option for ODBC and click Next.
  4. In the Server Name and Port Information window, enter:
    Field Description
    Server name Name of the DirectConnect server
    Port number Listener port number of the server

    Click Next.

  5. Select unixODBC Driver Manager and click Next.
  6. Enter the ECDA access service name to use for this server and click Next.
  7. The ECDA Server Summary and Build window displays the selections you have made. Review the information and click Create Server.
  8. (Optional) Start the DirectConnect server that you created and click Finish.
    Note: The service requires additional configuration to connect to the target database. To add this configuration, use DirectConnect Manager. For basic connectivity to the target database, start DirectConnect Manager and set ConnectionSpec1 to a data source name (DSN) in the odbc.ini file located in dc_install_dir/DC-15_0.
  9. Set the configuration property, SQLODBCCursors to driver in the dcany.cfg file.