| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Cannot get rid of 'Data Source' requirement |
« View previous topic :: View next topic » |
| Author |
Message
|
| TonyD |
 Posted: Sat Sep 18, 2004 6:15 pm Post subject: Cannot get rid of 'Data Source' requirement |
 |
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
I deployed a flow that referenced a function which accessed a DB2 table. The relevant node had the 'Data Source' property set. I subsequently removed the function reference from the flow, blanked out 'Data Source' and redeployed, but now get the error:
| Code: |
BIP2322E: Database error: SQL State 'IM002'; Native Error Code '0'; Error Text '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'
|
:although there is nothing in the flow that references any tables. If I restore the Data Source property the flow works OK.
I have tried all the usual ways to try to get around this (Rebuild Project, Close/Open Project, stop/start Workbench etc.) but none work. Has anyone else encountered this behaviour? |
|
| Back to top |
|
 |
| mgk |
| Posted: Sun Sep 19, 2004 1:42 pm Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hi,
Is there a function/procedure that references a DB in an ESQL schema that is referenced by the node in question? If so then this is your problem: every schema that is referenced (either directly or indirectly) by a node is deployed IN FULL to that node, whether or nor the ESQL code in that schema is used by that node.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| TonyD |
| Posted: Sun Sep 19, 2004 2:44 pm Post subject: |
|
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
MGK, thanks for the response.
The message flow project that contains my problem flow has a project reference to a project called 'CommonFunctions'. The function that accesses the database is located in this project. When I removed the ESQL that called the database-related function I left this project reference as there are other common functions that I need to use.
I gather from your response that any message flow project that contains a reference to 'CommonFunctions' will need to have the Data Source (that the function uses) specified in all Compute, Filter and Database nodes? Is this a correct reading?
I guess this was addressed in the responses to my thread of a few days ago:
http://www.mqseries.net/phpBB2/viewtopic.php?t=17515
:to which you also replied. However I had not appreciated that a project reference, as opposed to a direct reference by call, would also have this result. |
|
| Back to top |
|
|
| mgk |
| Posted: Mon Sep 20, 2004 1:00 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hi,
I think it may be the
| Quote: |
| other common functions that I need to use. |
that are causing your CommonFunctions Schema to be pulled in. If a node used NO code from this Schema then I think it would not be a problem, but as long as ANY code from this schema is used by a node then the WHOLE of this schema's code will be deployed to every node that references code in it. So your reading is correct, any node (Compute / Filter / DB ) that uses code in this feature will need to have its datasource set to the correct datasource. However, you would be better advised to seperate this DB function into a seperate schema that only nodes that needed it refered to. That way, you do not have to specify the datasource on nodes that do not need it.
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| 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
|
|
|
|
