This discussion is archived
1 Reply Latest reply: Oct 10, 2006 10:54 AM by 3004 RSS

ODBC and DB2 bind problems

3004 Newbie
Currently Being Moderated
<p>I am working my way through  the EIS 7.1.24 installationguide [AIX] and have hit a road block with ODBC. </p><p> </p><p>I have set up the odbc.ini file for DB2 and have confirmed thati can conect to the DB2 database through otherapplications.</p><p> </p><p>RECAP</p><p>When I run the follwing command:</p><p><span style=" font-family: CourierNew;">    /essapp/hyperion/common/ODBC/Merant/4.2/lib> ./bind19 db2data</span></p><p> </p><p>I get this reposnse: <span style=" font-family: CourierNew;">    Specified driver could not beloaded./essapp/hyperion/common/ODBC/Merant/4.2/lib ></span></p><p> </p><p>To make sure the driver is good [per Merant site],  I thenran:</p><p><span style=" font-family: CourierNew;">    /essapp/hyperion/common/ODBC/Merant/4.2/bin> ./ivtestlib ARdb219.so</span></p><p> </p><p>Which return this:</p><p><span style=" font-family: CourierNew;">    Load of ARdb219.so successful,qehandle is 0x200C89DC</span></p><p> </p><p><span style=" font-family: Arial;">Here's a view of the odbc.inifile {i had to hide some connection infor per security)</span></p><p> </p><p><span style=" font-family: Courier New;">[ODBC Data Sources]db2data=DB2 Source Data on AIX</span></p><p> </p><p><span style=" font-family: Courier New;">[db2data]Driver=/essapp/hyperion/common/ODBC/Merant/4.2/lib/ARdb219.soIpAddress=IPADDRESS</span></p><p><span style=" font-family: CourierNew;">Database=DATABASE</span></p><p><span style=" font-family: Courier New;">TcpPort=PORT</span></p><p><span style=" font-family: Courier New;">LogonID=USERNAME</span></p><p><span style=" font-family: CourierNew;">Password=PASSWORD</span></p><p><span style=" font-family: Courier New;">Package=</span></p><p><span style=" font-family: CourierNew;">Action=REPLACE</span></p><p><span style=" font-family: CourierNew;">QueryBlockSize=8</span></p><p><span style=" font-family: CourierNew;">CharSubTypeType=SYSTEM_DEFAULT</span></p><p><span style=" font-family: CourierNew;">ConversationType=SINGLE_BYTE</span></p><p><span style=" font-family: CourierNew;">CloseConversation=DEALLOC</span></p><p><span style=" font-family: CourierNew;">UserBufferSize=32</span></p><p><span style=" font-family: CourierNew;">MaximumClients=35</span></p><p><span style=" font-family: CourierNew;">GrantExecute=1</span></p><p><span style=" font-family: CourierNew;">GrantAuthid=PUBLIC</span></p><p><span style=" font-family: Courier New;">OEMANSI=1</span></p><p><span style=" font-family: CourierNew;">DecimalDelimiter=PERIOD</span></p><p><span style=" font-family: CourierNew;">DecimalPrecision=15</span></p><p><span style=" font-family: CourierNew;">StringDelimiter=SINGLE_QUOTE</span></p><p><span style=" font-family: CourierNew;">IsolationLevel=CURSOR_STABILITY</span></p><p><span style=" font-family: CourierNew;">ResourceRelease=DEALLOCATION</span></p><p><span style=" font-family: CourierNew;">DynamicSections=32</span></p><p><span style=" font-family: Courier New;">Trace=0</span></p><p><span style=" font-family: Courier New;">WithHold=0</span></p><p> </p><p>Any help would be much appreciated</p>