It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×10,907
×6,076
×145
×4

question asked: Mar 04 '13, 1:36 p.m.
question was seen: 4,481 times
last updated: Mar 05 '13, 7:39 a.m.

Related questions

FAQ - How this Forum works

How to configure unixODBC driver for RQM Live Reporting in RRDI?

0
1
Leonardo Marzo (249●6●48●52) | asked Mar 04 '13, 1:36 p.m.
 Hi everyone, 

I´m having problems with the set up of RQM Live Reporting for RRDI. I succeeded in configuring the UnixODBC driver for 32 bit. However, I´m getting this error when testing the connection with the command isql -v RQM Live:

[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
[ISQL]ERROR: Could not SQLConnect

This is mi environment:

OS: Linux Redhat 64 bit. 

Output of command odbcinst -j:
unixODBC 2.3.0
DRIVERS............: /opt/IBM/RRDI2/etl/odbc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/IBM/RRDI2/etl/odbc/odbc.ini
FILE DATA SOURCES..: /opt/IBM/RRDI2/etl/odbc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 4
SQLLEN Size........: 4
SQLSETPOSIROW Size.: 2

odbcinst.ini
[IBM Rational XML ODBC Driver]
Description=
Driver=/opt/IBM/RRDI2/etl/odbc/libratlxml.so
Driver64=/usr/local/lib
Setup=/opt/IBM/RRDI2/etl/odbc/libratlxmlS.so
Setup64=/usr/local/lib
LibPath=/opt/IBM/RRDI2/etl/jdbc
MaxActiveStatements=100
QueuingTimeout=100000
DefaultPageSize=1000
DefaultRetryTimes=10
Threading=0
UsageCount=2

jdbclogpath=/tmp/jdbc.log
Debug=1

#[ODBC]
Trace=Yes
TraceFile=/tmp/odbc_u.log

odbc.ini
[RQM Live]
Driver          = IBM Rational XML ODBC Driver
DataSource              = RQM Live
Description             =
Configuration           = /opt/IBM/RRDI2/_extra/rqm40-live.xdc


Everything is working properly on our RRDI except for Live Reporting. 


I would really appreciate you help. 

Thanks!

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Pascale Micaelli (1) | answered Mar 04 '13, 5:34 p.m.
Hi

I had the same problem. Try to copy odbc.ini and odbcinst.ini files in the directory /etc.

Pascale



Comments
Leonardo Marzo commented Mar 05 '13, 7:20 a.m.

 I tried that but the problem is still there. Did you succeeded in configure it in a Linux 64 bit? Have you installed any additional libraries? Could yo show me the values of the env variables needed? Thank you!
0
permanent link
Pascale Micaelli (1) | answered Mar 05 '13, 7:33 a.m.
I installed RRDI on Redhat 64bits and everything is Ok

Could you verify you file odbcinst.ini ?
In my file, the path for driver is :
LibPath=/u01/app/IBM/RRDI/etl/jdbc5


Comments
Leonardo Marzo commented Mar 05 '13, 7:39 a.m.

In mine the path is /opt/IBM/RRDI2/etl/jdbc and exists. Are you using Oracle? 

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.