系统集成 wmb 8.0

WMB 8.0 64位操作系统连接ODBC数据源的问题

[img]file:///C:UserswbiadminDocumentsTencent Files137387635ImageGroupImage2908[BHE}2SBVYVK)@2$F8IK.png[/img]

执行这个下列语句时,报错。
SET SQLSTR='select * from test';
SET rData.rdata[]=PASSTHRU(SQLSTR TO Database.MBDB);

异常如下:
ExceptionList

RecoverableException

File:CHARACTER:F:buildS000_PsrcDataFlowEngineImbDataFlowNode.cpp

Line:INTEGER:1129

Function:CHARACTER:ImbDataFlowNode::createExceptionList

Type:CHARACTER:ComIbmTimeoutNotificationNode

Name:CHARACTER:CSRTCAdapter#FCMComposite_1_2

Label:CHARACTER:CSRTCAdapter.超时通知

Catalog:CHARACTER:BIPmsgs

Severity:INTEGER:3

Number:INTEGER:2230

Text:CHARACTER:Node throwing exception

RecoverableException

File:CHARACTER:F:buildS000_PsrcDataFlowEngineImbComputeNode.cpp

Line:INTEGER:489

Function:CHARACTER:ImbComputeNode::evaluate

Type:CHARACTER:ComIbmComputeNode

Name:CHARACTER:CSRTCAdapter#FCMComposite_1_3

Label:CHARACTER:CSRTCAdapter.计算

Catalog:CHARACTER:BIPmsgs

Severity:INTEGER:3

Number:INTEGER:2230

Text:CHARACTER:Caught exception and rethrowing

RecoverableException

File:CHARACTER:F:buildS000_PsrcDataFlowEngineImbRdlImbRdlStatementGroup.cpp

Line:INTEGER:627

Function:CHARACTER:SqlStatementGroup::execute

Type:CHARACTER:

Name:CHARACTER:

Label:CHARACTER:

Catalog:CHARACTER:BIPmsgs

Severity:INTEGER:3

Number:INTEGER:2488

Text:CHARACTER:Error detected, rethrowing

Insert

Type:INTEGER:5

Text:CHARACTER:.CSRTCAdapter_compute.Main

Insert

Type:INTEGER:5

Text:CHARACTER:8.3

Insert

Type:INTEGER:5

Text:CHARACTER:SET rData.rdata[ ] = SPECIFICPASSTHRU(SQLSTR, Database.ESBDB);

DatabaseException

File:CHARACTER:F:buildS000_PsrcDataFlowEngineImbOdbc.cpp

Line:INTEGER:3138

Function:CHARACTER:ImbOdbcConnection::checkRcInner

Type:CHARACTER:

Name:CHARACTER:

Label:CHARACTER:

Catalog:CHARACTER:BIPmsgs

Severity:INTEGER:3

Number:INTEGER:2321

Text:CHARACTER:Root SQL exception

Insert

Type:INTEGER:2

Text:CHARACTER:-1

Insert

Type:INTEGER:14

Text:CHARACTER:odbc32.dll

DatabaseException

File:CHARACTER:F:buildS000_PsrcDataFlowEngineImbOdbc.cpp

Line:INTEGER:3316

Function:CHARACTER:ImbOdbcConnection::checkRcInner

Type:CHARACTER:

Name:CHARACTER:

Label:CHARACTER:

Catalog:CHARACTER:BIPmsgs

Severity:INTEGER:3

Number:INTEGER:2322

Text:CHARACTER:Child SQL exception

Insert

Type:INTEGER:5

Text:CHARACTER:HYC00

Insert

Type:INTEGER:2

Text:CHARACTER:0

Insert

Type:INTEGER:5

Text:CHARACTER:[IBM][ODBC Oracle Wire Protocol driver]Optional feature not implemented.
参与4

3 同行回答

html1234 html1234 软件开发工程师 IBM
请问楼主配置过MB与数据库连接池没?显示全部
请问楼主配置过MB与数据库连接池没? 收起
软件开发 · 2015-05-10
浏览1043
f9511619 f9511619 软件开发工程师 siren
环境是 windows server2008 虚拟机显示全部
环境是 windows server2008 虚拟机 收起
系统集成 · 2015-04-09
浏览1027
html1234 html1234 软件开发工程师 IBM
你好,连接数据库。需要注意几点就行:在wbiadmin用户配置好odbc.int,重启代理,mqsicvp进行连接测试。谢谢!显示全部
你好,连接数据库。需要注意几点就行:在wbiadmin用户配置好odbc.int,重启代理,mqsicvp进行连接测试。谢谢! 收起
软件开发 · 2015-04-09
浏览1036

提问者

f9511619
软件开发工程师 siren
评论67

问题状态

  • 发布时间:2015-04-09
  • 关注会员:1 人
  • 问题浏览:3931
  • 最近回答:2015-05-10
  • X社区推广