| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQSI with Informix on Solaris 8 |
« View previous topic :: View next topic » |
| Author |
Message
|
| dlamond |
 Posted: Mon Jul 22, 2002 6:43 am Post subject: MQSI with Informix on Solaris 8 |
 |
|
Newbie
Joined: 28 May 2002
Posts: 9
Location: Montreal
|
Hello,
Anyone tried MQSI 2.1 database nodes with an Informix database on Solaris 8? Did it worked? if yes, can you tell me what odbc driver did you used?
Thank you,
_________________
Daniel Lamond
IBM Certified Specialist MQSeries
IBM Certified Specialist MQSeries Integrator |
|
| Back to top |
|
 |
| dlamond |
| Posted: Fri Jul 26, 2002 7:23 am Post subject: |
|
|
Newbie
Joined: 28 May 2002
Posts: 9
Location: Montreal
|
Ok, here is more on what I tried.
I have a simple flow with one MQINPUT node, two MQOUTPUT nodes (one for success and one for failure), one DataInsert node and two trace nodes (one between MQINPUT and failure, and one between DataInsert and failure)
With the following configuration.
MQSI 2.1 broker on Solaris 8
Informix Dynamic Server 7.31.UD2R1 on Solaris 8
Informix 3.3 ODBC driver on Solaris 8 and DataDirect 4.1 ODBC driver on Solaris 8
for both ODBC drivers the output is
Insert trace = [(
(0x1000000)RecoverableException = (
(0x3000000)File = '/build/S210_P/src/DataFlowEngine/ImbDataFlowNode.cpp'
(0x3000000)Line = 536
(0x3000000)Function = 'ImbDataFlowNode::createExceptionList'
(0x3000000)Type = 'ComIbmDatabaseNode'
(0x3000000)Name = 'df3b7924-ef00-0000-0080-b6956dcfd43e.0408070c-0800-0000-0100-090507050000'
(0x3000000)Label = 'INFORMIX.FLOW.Insert Informix.Database1'
(0x3000000)Text = 'Node throwing exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)DatabaseException = (
(0x3000000)File = '/build/S210_P/src/DataFlowEngine/ImbOdbc.cpp'
(0x3000000)Line = 143
(0x3000000)Function = 'ImbOdbcHandle::checkRcInner'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'Root SQL exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2321
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '-1'
)
(0x1000000)DatabaseException = (
(0x3000000)File = '/build/S210_P/src/DataFlowEngine/ImbOdbc.cpp'
(0x3000000)Line = 234
(0x3000000)Function = 'ImbOdbcHandle::checkRcInner'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'Child SQL exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2322
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'IM003'
)
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '80'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'Specified driver could not be loaded'
)
)
)
)
)]
I also tried on Windows
MQSI 2.1 broker on Windows 2000
Informix Dynamic Server 7.31.UD2R1 on Solaris 8
Informix Dynamic Server 7.31 TC5 on Windows NT 4.0 Server
Informix 3.32 ODBC driver on Windows 2000
for both ODBC drivers Informix tells me I'm connected, but the trace output is
Insert trace = [(
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S210_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x3000000)Line = 536
(0x3000000)Function = 'ImbDataFlowNode::createExceptionList'
(0x3000000)Type = 'ComIbmDatabaseNode'
(0x3000000)Name = 'df3b7924-ef00-0000-0080-b6956dcfd43e.0408070c-0800-0000-0100-090507050000'
(0x3000000)Label = 'INFORMIX.FLOW_NT.Insert Informix.Database1'
(0x3000000)Text = 'Node throwing exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S210_P\src\DataFlowEngine\ImbOdbc.cpp'
(0x3000000)Line = 993
(0x3000000)Function = 'ImbOdbcConnection::setDatabasePlatform'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'Unsupported database'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2112
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'Attempted a connection to an unsupported database'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'Informix <-some garbage->'
)
)
)
)]
I know Informix is not in the supported database list, but since I'm using ODBC, it should work. Besides that, Informix is the Corporate Database here, so there is no way around it and it's going to be a show stopper for MQSI. Any help is greatly welcome.
_________________
Daniel Lamond
IBM Certified Specialist MQSeries
IBM Certified Specialist MQSeries Integrator |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
