Configuring ECDA Option for ODBC

The following describes server creation for the ODBC-accessible target database for ECDA Option for ODBC.

1. Start the Create Server wizard by entering:

   DCWizard.bat
   

2. The Welcome Create Server Wizard window appears, Click Next.

   The Create DirectConnect Server Options window appears.

3. Select the ECDA Option for ODBC option. Click Next.

   The Server Name and Port Information window appears.

4. Enter the Server Name for the new DirectConnect server and the Port Number that you want the server to “listen” on. Click Next.

   The DirectConnect Service Name window appears.

5. Enter the ECDA access service name that you want to use for this server. Click Next. The ECDA Server Summary and Build window appears.

6. Verify the ECDA Server information that appears.

   If correct select Create Server. The Start DirectConnect Server (Optional) window appears.

   If incorrect, select the Back button to change the information.

7. Optionally, start the DirectConnect server that you created. Click Finish

   The service requires additional configuration to connect to the target database. This additional configuration can be added using DirectConnect Manager. For basic connectivity to the target database, the next step is to start DirectConnect Manager and set ConnectionSpec1 to a data source name (DSN) contained in the odbc.ini file located at:

   <dc_install_dir>\DC-15_0\odbc.ini.
   

8. Set the Configuration property, SQLODBCCursors to driver in the dcany.cfg file.