Instruction manual

ODBC Driver and Installation CentreVu® CMS Open Database Connectivity
Solaris Client Installation 2-18
Test ODBC
Connectivity
2
On the Solaris client, initiate the test application to verify connectivity with
the following procedure:
1. Enter cd /usr/openlink/odbcsdk/examples to change directories
to
/usr/openlink/odbcsdk/examples .
2. Enter ./odbctest to run
odbctest .
3. At the “Enter ODBC connect string” prompt, enter:
DSN = Informix7(or the valid value for your CMS);
UID = Valid _UNIX_User_on_Server;
PWD = User_password to set these parameters (DSN = data
source name, UID = user ID, and PWD = password).
4. At
SQL > , enter a valid SQL query, for example:
select SPLIT, ACDCALLS from hsplit where ROW_DATE =
“6/27/98” and STARTTIME = 1600 to test data connection.
5. Enter exit to exit.
If an error occurs, an error message is reported and the test application
closes.
Possible Failure
Causes
2
A test application error could result from one of the following causes:
●
The driver is not active on the CentreVu CMS server. Verify that the
ODBC driver is active on the server by entering ps -ef | grep
oplrqb. You should see an
oplrqb process running.
●
There was an error in the ODBC.connect string entry. Resolve this
by re-entering the correct DSN, host, user ID and password at the
ODBC.connect string prompt.
●
The .odbc.ini file does not reside in the initiator’s $HOME directory.
●
The .odbc.ini file is incorrect. Verify that the entered host is correct
the database is
/cms/db/inf/cms .
●
The LD_LIBRARY_PATH is not set. Enter echo
$LD_LIBRARY_PATH to ensure that
LD_LIBRARY_PATH is
included in the display (see “
Test ODBC Connectivity” for more
information).
●
The UDBCINI is not set. Enter echo $UDBCINI to ensure that
$HOME/.odbc.ini is included in the display. See “Configuration
Procedure” in this section for more information.
●
The data source is not consistent with the cmsrqb_init entry. Verify
the data source you have entered (
Informix 7).