| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SQLServer database ODBC Source on AIX Problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| diegoH |
 Posted: Fri Dec 01, 2006 9:41 am Post subject: SQLServer database ODBC Source on AIX Problem |
 |
|
Newbie
Joined: 01 Dec 2006
Posts: 4
Location: Argentina
|
Hello all!
I am having a problem to get configured an ODBC source to a SQLServer database on a WebSphere Message Broker 6.0 (AIX).
In my .odbc.ini i added a new line in [ODBC Data Sources] like:
| Code: |
| SQLSERVDB=SQL Server Database |
And a stanza like:
| Code: |
[SQLSERVDB]
Driver=/usr/IBM/mqsi/6.0/merant/lib/UKmsss20.so
Description=DataDirect 5.0 SQL Server Wire Protocol
Address=<hostname>,<port>
Database=SQLSERVDB
AnsiNPW=Yes
QuotedId=No
|
Where <hostname> is the SQLServer HostName and <port> it's port.
Then I added the datasourse with the mqsisetdbparms command:
$ mqsisetdbparms MY_BROKER -n SQLSERVDB -u <user_id> -p <password>
where <user_id> and <password> are the credentials of the database user.
After that, when a message passes through the data flow that must insert a row in the mentioned database I 've got this message on the logs:
| Code: |
Dec 1 11:42:57 localhost user:err|error WebSphere Broker v6002[925892]: (MY_BROKER.default value)[3413]BIP2628E: Exception
condition detected on input node 'InsertNode.MQInput'. : MY_BROKER.5a1b88cf-0d01-0000-0080-e2be86d6d200: /build/S600_P/src/DataFlowEngine/ImbCommonInputNode.cpp: 1070: ImbCommonInputNode::run: ComIbmMQInputNode: InsertNode#FCMComposite_1_1
Dec 1 11:42:57 localhost user:err|error WebSphere Broker v6002[925892]: (MY_BROKER.default value)[3413]BIP2230E: Error detected whilst processing a message in node 'InsertNode.Database'. : MY_BROKER.5a1b88cf-0d01-0000-0080-e2be86d6d200: /build/S600_P/
src/DataFlowEngine/ImbDatabaseNode.cpp: 295: ImbDatabaseNode::evaluate: ComIbmDatabaseNode: InsertNode#FCMComposite_1_3
Dec 1 11:42:57 localhost user:err|error WebSphere Broker v6002[925892]: (MY_BROKER.default value)[3413]BIP2321E: Database
error: ODBC return code '-1'. : MY_BROKER.5a1b88cf-0d01-0000-0080-e2be86d6d200: /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 22
7: ImbOdbcHandle::checkRcInner: :
Dec 1 11:42:57 localhost user:err|error WebSphere Broker v6002[925892]: (MY_BROKER.default value)[3413]BIP2322E: Database
error: SQL State 'IM002'; Native Error Code '0'; Error Text '[DataDirect][ODBC lib] Data source name not found and no default
driver specified'. : AUTBKD.5a1b88cf-0d01-0000-0080-e2be86d6d200: /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 355: ImbOdbc
Handle::checkRcInner: : |
Any Suggestions?
_________________
Saludos / Regards,
Diego. |
|
| Back to top |
|
 |
| JosephGramig |
| Posted: Fri Dec 01, 2006 10:45 am Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
Was the broker running when you executed the command?
_________________
Joseph
Administrator - IBM WebSphere MQ (WMQ) V6.0, IBM WebSphere Message Broker (WMB) V6.1 & V6.0
Solution Designer - WMQ V6.0
Solution Developer - WMB V6.1 & V6.0, WMQ V5.3 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Dec 01, 2006 10:48 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I would double-check the message flow to make sure it is using 'SQLSERVDB' as the data source name.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| diegoH |
| Posted: Fri Dec 01, 2006 12:44 pm Post subject: |
|
|
Newbie
Joined: 01 Dec 2006
Posts: 4
Location: Argentina
|
| JosephGramig wrote: |
| Was the broker running when you executed the command? |
You cannot run mqsisetdbparms while broker is running, right? so I stopped the broker, ran the command and start it again. Is there something wrong in this procedure?
_________________
Saludos / Regards,
Diego. |
|
| Back to top |
|
|
| diegoH |
| Posted: Fri Dec 01, 2006 1:13 pm Post subject: |
|
|
Newbie
Joined: 01 Dec 2006
Posts: 4
Location: Argentina
|
| jefflowrey wrote: |
| I would double-check the message flow to make sure it is using 'SQLSERVDB' as the data source name. |
Thanks to all, seems that developers changed the DS name 
_________________
Saludos / Regards,
Diego. |
|
| 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
|
|
|
|
