To create a server that will use a unixODBC driver
manager
Start the Create Server wizard by entering:
DCWizard.sh
When the Welcome Create Server Wizard window appears, Click Next. The Create DirectConnect Server Options window appears.
Select the ECDA Option for ODBC option and click Next.
The Server Name and Port Information window appears.
Enter the Server Name for the new DirectConnect server and the Port Number that you want the server to “listen” on. Click Next.
The ECDA - ODBC Driver Manager Options window appears.
Select the unixODBC Driver Manager option and click Next. The DirectConnect Service Name window appears.
Enter the ECDA access service name that you want to use for this server and click Next. The ECDA Server Summary and Build window appears.
If correct, select Create Server. The Start DirectConnect Server (Optional) window appears.
If incorrect, click Back to change the information.
Optionally, you can 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.
Set the configuration property called SQLODBCCursors to driver in the dcany.cfg file.
