MQSeries.net :: View topic

lium · Posted: Sun Jan 26, 2014 1:03 am Post subject:

Hi, I ran into the ODBC problem as following when IIB processes the DataCaptureStore

I am using the DataDirect for Oracle. The connection has been tested without any problem.

Anyone has any idea?

Thanks,

Log Name: Application
Source: IBM Integration v9000
Date: 1/26/2014 8:35:44 AM
Event ID: 2196
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: WIN-JFFTF45GEQM
Description:
( BHBK.BHSV ) A database error occurred when processing a message for the data capture store ''POCDataCaptureStore''. The error was ''ImbOdbcConnection::checkRcInner() reported 'Root SQL exception' with values... '-1' ''odbc32.dll'' Nested Item{ ImbOdbcConnection::checkRcInner() reported 'Child SQL exception' with values... ''IM001'' '0' ''[Microsoft][ODBC Driver Manager] Driver does not support this function'' }''.

Check that the database is correctly defined and available, and that the ODBC definition is correct. If the error message does not contain enough information, check the database logs. If the problem persists, contact your IBM support center.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="IBM Integration v9000" />
<EventID Qualifiers="49152">2196</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2014-01-26T08:35:44.000000000Z" />
<EventRecordID>1592835</EventRecordID>
<Channel>Application</Channel>
<Computer>WIN-JFFTF45GEQM</Computer>
<Security />
</System>
<EventData>
<Data>BHBK.BHSV</Data>
<Data>'POCDataCaptureStore'</Data>
<Data>'ImbOdbcConnection::checkRcInner() reported 'Root SQL exception' with values... '-1' ''odbc32.dll'' Nested Item{ ImbOdbcConnection::checkRcInner() reported 'Child SQL exception' with values... ''IM001'' '0' ''[Microsoft][ODBC Driver Manager] Driver does not support this function'' }'</Data>
<Binary>350039003200340000004200480042004B002E00360030003400360033003400380061002D0034003200300031002D0030003000300030002D0030003000380030002D00650066003900650036006200610061003000370065006200000046003A005C006200750069006C0064005C0073006C006F00740031005C0053003000300030005F0050005C007300720063005C00440061007400610046006C006F00770045006E00670069006E0065005C004D00650073007300610067006500530065007200760069006300650073005C0049006D0062005200650063006F00720064005400680072006500610064002E00630070007000000037003900390000004D0065007300730061006700650043006F006E00730075006D0065007200000000000000</Binary>
</EventData>
</Event>