Completing CONNX Installation for UNIX ODBC Drivers
This section continues the description of the UNIX installation for systems with ODBC drivers.
Note:
When using the ODBC interface, you must install an ODBC driver manager. Several driver managers are available and Software AG does not endorse one over the other. The examples below are based on the Open Source ODBC Driver Manager unixODBC.
1. Create the connxdriver.template file in a text editor and enter the information required to register the driver with your driver manager.
Once CONNX is installed on the UNIX system, it can be accessed through an ODBC driver manager. The ODBC driver manager defines how to register the CONNX driver and/or the name of your data source (DSN).
The values in the following example are suggested values.
[CNXODBC]
The CONNX driver name, including the brackets.
Software AG recommenda you use CNXODBC as the driver name.
Description
= CONNX ODBC Driver The description
is treated as a comment; optional.
Driver
= /installdirectory/connx/libxx/libconnx32.so
Setup
= /installdirectory/connx/libxx/libconnx32.so
installdirectory is the location of the CONNX UNIX client.
libxx
is the 32-bit or 64-bit lib directory. For 64bit, the value is
lib64. For 32-bit, the value is lib32.
The extension of the libconnx32 file changes depending on the platform.
The example shows .so for Linux and Sun;
other extensions are .a for AIX, and .sl for HP-UX.
Threading = 2 Gives
the number of threads for multitasking. Minimum multitasking value is 2.
2. Run odbcinst -i -d -f connxdriver.template to register the driver with unixODBC.
3. Create the connxdsn.template file in a text editor and enter the information required to register the DSN with your driver manager.
[CONNXDSN]
The data source name, including the brackets.
Description
= CONNX Samples Data Source
The description is treated as a comment; optional.
Driver
= [CNXODBC]
Since the driver is registered in the previous step, use the format Driver=[drivername]
DATADICTIONARY
= /installdirectory/connx/samples.cdd
This is the path and filename for the data dictionary.
This file cannot be created or edited in a UNIX environment.
Create or edit this file on Windows, then send it via ftp it to your UNIX system.
APPLICATION
= <application or database>
Your application or database type, such as Adabas or CISAM.
If you are running multiple applications or database types, leave this blank.
Trace
= No Turn
trace on (yes) for debugging.
TraceFile
= sql.log Ignored
if Trace = No; otherwise the trace output goes here.
UserName
= CONNX user ID
Password
= CONNX password
The UserName and Password can be left blank.
If they are blank, when you connect to CONNX, you will be prompted for that information.
4. Run odbcinst -i -s -l -f connxdsn.template to register the DSN with UnixODBC.
5. Use a query program to connect to the data source using the newly created DSN to retrieve data.
6. The iSQL utility that enables you to test connections is installed with unixODBC. After you create a DSN, in preparation for connecting to your data source, run isql.
isql {cmd options}
[dsn name] {username} {password}
7. The connection is complete. If the connection is not successful, the [ISQL]ERROR message appears. For more information on what to do if the connection fails, use the -v option (verbose mode).