Product specifications

The configuration files are located in the connectionserver-install-dir/connectionServ

er/odbc directory.

Use an XML editor to open the odbc.sbo file for editing.

Locate the following section:

...

<Library Platform="Unix">dbd_wddodbc</Library>

<Library Platform="Unix">dbd_ddodbc</Library>

</Libraries>

<Parameter Name="Charset Table" Platform="Unix">datadirect</Parameter>

...

</DataBases>

Comment out the first two rows for DataDirect and uncomment one of the next two rows. Make sure

you put the row you uncomment on top of the section, so that it can be read first. Comment out the

<Parameter Name="CharSet Table" Platform="Unix"> element.

Note:

• dbd_wddodbc specifies the DataDirect-based ODBC2 Unicode driver

• dbd_ddodbc specifies the DataDirect-based ODBC2 non-Unicode driver

• dbd_wuxodbc specifies the unixODBC-based ODBC2 Unicode driver

• dbd_uxodbc specifies the unixODBC-based ODBC2 non-Unicode driver

Save and close the odbc.sbo file.

Use an XML editor to open the odbc.prm file for editing.

Add or update any information specific to the database.

Note:

The odbc.prm file may not contain information about specific functions of the database.

Save and close the odbc.prm file.

Install the relevant ODBC drivers on your UNIX machine.

10.

Configure the data source by editing the odbc.ini file.

11.

Save and close the odbc.ini file.

12.

Run the connection wizard.

The ODBC driver that you have configured appears in the list of available connections under Generic.

13.

Select the ODBC driver and use the wizard to configure the connection.

When you complete this task, the connection to the data source is available for use through generic

ODBC with unixODBC driver manager.