MQSeries.net :: View topic - WMBv6.1->Informix client error (SQLSetConnectAttr failed)

broker_new · Posted: Tue Jan 26, 2010 2:09 pm Post subject:

Hi Guys,

have anyone come acrossed the following error, i have installed informix 64bit client and it updated the odbc64.ini and sqlhosts file to connect the database.

[Informixdb]
Driver=libinfWrapper64.so
Description=IBM Informix ODBC Driver
ServerName=informixserver
Database=db
LogonID=xxxx
Password=xxxx

<ExceptionList>
<RecoverableException>
<File>/build/S610_P/src/DataFlowEngine/ImbComputeNode.cpp</File>
<Line>464</Line>
<Function>ImbComputeNode::evaluate</Function>
<Type>ComIbmComputeNode</Type>
<Name>Test_MsgFlow#FCMComposite_1_3</Name>
<Label>Test_MsgFlow.CallInformix_StoredProcedure</Label>
<Catalog>BIPv610</Catalog>
<Severity>3</Severity>
<Number>2230</Number>
<Text>Caught exception and rethrowing</Text>
<DatabaseException>
<File>/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp</File>
<Line>333</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type></Type>
<Name></Name>
<Label></Label>
<Catalog>BIPv610</Catalog>
<Severity>3</Severity>
<Number>2393</Number>
<Text>Root SQL exception</Text>
<Insert>
<Type>2</Type>
<Text>-1</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>Test_Flow</Text>
</Insert>
<DatabaseException>
<File>/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp</File>
<Line>453</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type></Type>
<Name></Name>
<Label></Label>
<Catalog>BIPv610</Catalog>
<Severity>3</Severity>
<Number>2322</Number>
<Text>Child SQL exception</Text>
<Insert>
<Type>5</Type>
<Text>28000</Text>
</Insert>
<Insert>
<Type>2</Type>
<Text>-952</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>x</Text>
</Insert>
</DatabaseException>
<DatabaseException>
<File>/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp</File>
<Line>453</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type></Type>
<Name></Name>
<Label></Label>
<Catalog>BIPv610</Catalog>
<Severity>3</Severity>
<Number>2322</Number>
<Text>Child SQL exception</Text>
<Insert>
<Type>5</Type>
<Text>IM006</Text>
</Insert>
<Insert>
<Type>2</Type>
<Text>0</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>[DataDirect][ODBC lib] Driver's SQLSetConnectAttr failed</Text>
</Insert>
</DatabaseException>
</DatabaseException>
</RecoverableException>
</ExceptionList>
_________________
IBM ->Let's build a smarter planet