Using DataDirect Driver

Create a server using the DataDirect driver.

Prerequisites

Install the DataDirect ODBC software on the same machine where 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.

Task

Start the Create Server wizard. Enter:
```
DCWizard.sh
```
On the Welcome Create Server Wizard window, click Next.
Select ECDA Option for ODBC and click Next.
In the Server Name and Port Information window, enter:

Field Description

Server name Name of new DirectConnect server

Port number Listener port number of the server

Click Next.
Select the DataDirect Driver Manager option to use for this server and click Next.
Specify the path to the driver manager:
- Within the DataDirect installation, for example:
```
datadirect_install_dir/lib/libodbc.so
```
- Supported libraries, for example:
```
datadirect_install_dir/lib/
```
- odbc.ini file to use, for example:
```
datadirect_install_dir/odbc.ini/
```
Click Next.
Enter the ECDA access service name to use for this server and click Next.
The ECDA Server Summary and Build window displays the selections you have made. Review the information and click Create Server.
(Optional) Start the DirectConnect server that you created to validate the server configuration.
If you exit from this wizard, the DirectConnect server you have started continues to execute. To skip this step, 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.
Set the configuration property, SQLODBCCursors to driver in the dcany.cfg file.

Field	Description
Server name	Name of new DirectConnect server
Port number	Listener port number of the server