Instruction manual
ODBC Driver and Installation
CentreVu®
CMS Open Database Connectivity
Solaris Client Installation 2-17
Configuration
Procedure
2
The
cms_odbc.ini
file located in
/usr/openlink
must be modified and
placed in the
$HOME
directory as
.odbc.ini
for each user that will initiate
the client application. First edit the
cms_odbc.ini
file, then copy it to
$HOME/.odbc.ini
. The
cms_odbc.ini
file resides in
/usr/openlink
.
The host parameter in the
Informix
connection segment must be
changed. The
Informix
segment will be edited. The ServerType field
should be set to the version of
Informix
that CMS is using (
Informix
5.x for
R3V5 CMS,
Informix
7.1 for R3V5u CMS or
Informix
7.2 for R3V6 and
R3V8 CMS). The modified
Informix
section should look like the following
example, with your default host name entered in the Host parameter field:
[
Informix
7]
Driver =
/usr/openlink/client/odbcsdk/lib/oplodbc.so
Host = YOUR DEFAULT HOST NAME
ServerType = Informix7.2
ServerOptions =
Database = /cms/db/inf/cms
Options =
ReadOnly =
FetchBufferSize = 60
To correctly resolve database connectivity, the .odbc.ini file must exist in
the $HOME directory of the initiating user on the ODBC client. The client
application will fail if it is initiated by a user who does not have
an .odbc.ini file. The following steps complete the client administration:
1. Enter cd /usr/openlink to change to the
OpenLink
directory.
2. Edit the host parameter in the
Informix
section of the cms_odbc.ini
file (as described on the previous page).
3. Copy the cms_odbc.ini file to $HOME/.odbc.ini.
4. Enter cd $HOME to change to your home directory.
5. Enter vi .profile to edit your
.profile
file.
6. Enter export LD_LIBRARY_PATH =
/usr/openlink/odbcsdk/lib:$LD_LIBRARY_PATH to export
LD_LIBRARY_PATH
.
7. Enter export UDBCINI = $HOME/.odbc.ini to export
UDBCINI
.
8. Enter .wq to exit your
.profile
edit.
9. Enter . .profile to source your
.profile
.
Once the
Solaris
client software is installed and configured, you can
proceed with writing your application using the ODBC API.
!
CAUTION:
!
CAUTION: