MQSeries.net :: View topic - Defining a Data Source

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Defining a Data Source

Defining a Data Source

« View previous topic :: View next topic »

Author

Message

semcgurk

Posted: Thu Sep 11, 2014 4:27 am Post subject: Defining a Data Source

Newbie

Joined: 14 Nov 2013
Posts: 9

Hi there,

I am trying to use a 'Database' node in my message flow to interact with a database.

I have defined a Database Connection in my project and am trying to associate these with a 'Database' node in my message flow.

The only way that I can see to associate these two is to set the 'Data source' property for the 'Database' node to the same name as the Database Connection.

However, when I try and run the message flow, I get the following error message:

Code:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Can anyone tell me what I have been doing wrong?

Thanks,

SeÃ¡n

Vitor

Posted: Thu Sep 11, 2014 5:01 am Post subject: Re: Defining a Data Source

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

semcgurk wrote:

Can anyone tell me what I have been doing wrong?

The Database Connection in your project is what your Toolkit is using to validate the Database code you're producing (column names and so forth; it's how it produces those yellow triangles when you spell something wrong.

This has nothing to do with the environment in which the flow is running, where you'll need to set up and ODBC for the flow to use by whatever method the OS that the flow's running in requires.
_________________
Honesty is the best policy.
Insanity is the best defence.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Defining a Data Source

Jump to:

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

Protected by Anti-Spam ACP