Product specifications

5.5.2 To create a generic ODBC3 connection

The following procedure shows how to configure a generic ODBC connection to a database with the

following assumptions:

• The driver is ODBC3

• The driver supports the unixODBC driver manager

Navigate to the directory that contains the odbc.sbo and odbc.prm files.

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_wddodbc3</Library>

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

</Libraries>

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

...

</DataBases>

Comment the first two rows for DataDirect and uncomment one of the next four 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_wddodbc3 specifies the DataDirect-based ODBC3 Unicode driver

• dbd_ddodbc3 specifies the DataDirect-based ODBC3 non-Unicode driver

• dbd_wuxodbc3 specifies the unixODBC-based ODBC3 Unicode driver

• dbd_uxodbc3 specifies the unixODBC-based ODBC3 non-Unicode driver

• dbd_wux32odbc3 specifies the unixODBC-based ODBC3 Unicode driver with 32-bit API rather

than 64-bit (available only on 64-bit platforms)

• dbd_ux32odbc3 specifies the unixODBC-based ODBC3 non-Unicode driver with 32-bit API

rather than 64-bit (available only on 64-bit platforms)

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.

2012-03-1561

Creating a connection