The following describes server creation for the ODBC-accessible target database for ECDA Option for ODBC.
To create a server for ODBC
Start the Create Server wizard by entering:
DCWizard.bat
The Welcome Create Server Wizard window appears, Click Next.
The Create DirectConnect Server Options window appears.
Select the ECDA Option for ODBC option. 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 DirectConnect Service Name window appears.
Enter the ECDA access service name that you want to use for this server. Click Next. The ECDA Server Summary and Build window appears.
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.
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.
Set the Configuration property, SQLODBCCursors to driver in the dcany.cfg file.
