DataDirect driver

Before you create a DirectConnect server:

Install the DataDirect ODBC software on the same machine that you are installing the ODBC option.

Configure your DataDirect odbc.ini file with a data source name (DSN) for your target database. Verify connectivity using the DataDirect tools.

To create a server using a DataDirect driver

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 DataDirect Driver Manager option to use for this server. Click Next. The Driver Manager Information window appears.

Specify the following from the browse files and directories:

The path to the driver manager within the DataDirect installation, for example:
```
<datadirect_ install_dir>/lib/libodbc.so
```
The path to the Driver Manager support libraries, for example:
```
<datadirect_install_dir>/lib/
```
The path to the Driver Manager odbc.ini file you want to use, for example:
```
<datadirect_install_dir>/odbc.ini/
```
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, click Back to change the information.

Optionally, you can start the DirectConnect server that you created to validate the server configuration. If you exit from this wizard, the DirectConnect server you have started will continue to execute. To skip this step, click Finish.

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, the next step is to start DirectConnect Manager and set ConnectionSpec1 to a data source name (DSN) contained in the odbc.ini file.

Set the configuration property called SQLODBCCursors to driver in the dcany.cfg file.