| Author |
Message
|
| siva.kasetty |
 Posted: Mon Apr 28, 2008 8:59 pm Post subject: Exception while connecting database from Mapping Node in MB |
 |
|
Apprentice
Joined: 17 Mar 2008
Posts: 45
|
Hi,
My flow like this MQInput->Mappingnode->MQOutput
From mapping node i am trying to get the target values from database.
but i am getting Datasource Name not found exception.
i am created a DSN for my database and spcified in my Mapping node properties still i am getting the exception.
Need help on this. |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Mon Apr 28, 2008 9:16 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
Are u able to login to that DSN using the user id provided from your SQLPrompt or rather dos prompt itself..
_________________
Cheers |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Apr 29, 2008 12:27 am Post subject: Re: Exception while connecting database from Mapping Node in |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| siva.kasetty wrote: |
i am created a DSN for my database and spcified in my Mapping node properties still i am getting the exception.
|
Is the DSN you've created for broker or toolkit?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| siva.kasetty |
| Posted: Tue Apr 29, 2008 5:23 am Post subject: |
|
|
Apprentice
Joined: 17 Mar 2008
Posts: 45
|
Hi AkankshA,Vitor
Thanks for your replay.
i am tried in two ways
1.using the DSN which is created at the time of creating a broker
2. creating new database and creating new DSN for that.
But still i ma getting the exception.
Text = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
and
i dont know hwo to check the DSN using SQL promt |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Apr 29, 2008 5:28 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| siva.kasetty wrote: |
Text = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
|
Let me ask again, more plainly: is this a broker error or a toolkit error?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| siva.kasetty |
| Posted: Tue Apr 29, 2008 5:34 am Post subject: |
|
|
Apprentice
Joined: 17 Mar 2008
Posts: 45
|
Hi vitor,
I am getting this exception while running my flow. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Apr 29, 2008 5:51 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| siva.kasetty wrote: |
| I am getting this exception while running my flow. |
I'm assuming (as you've not said) the flow is running on a Windows box. Check the DSN is spelt correctly, and is defined at system level not user level. Check the DSN is defined correctly by using Excel or similar to pull data through it. Check that the flow is referencing the right DSN. Can the toolkit use the DSN, does it use the same DSN and can they be swapped over for test purposes? Do other DSNs on the same machine and/or database operate correctly?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Apr 29, 2008 5:52 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Does Windows believe this is a System DSN, or a User DSN?
Did you use the correct driver for the database type?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| siva.kasetty |
| Posted: Wed Apr 30, 2008 2:05 am Post subject: |
|
|
Apprentice
Joined: 17 Mar 2008
Posts: 45
|
thanks for your replay.
i got the solution, |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Apr 30, 2008 2:30 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| siva.kasetty wrote: |
| i got the solution, |
Care to post it, for the benefit of the next person with this problem? 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| siva.kasetty |
| Posted: Wed Apr 30, 2008 2:44 am Post subject: |
|
|
Apprentice
Joined: 17 Mar 2008
Posts: 45
|
thanks for ur advise.
i will do it. |
|
| Back to top |
|
|
| siva.kasetty |
| Posted: Thu May 01, 2008 11:15 pm Post subject: |
|
|
Apprentice
Joined: 17 Mar 2008
Posts: 45
|
Hi ,
when u face this problem ,please check the dsn name which your created.
whether broker able to listen this DSN or not, when ur selecting DSN from mapping node it gives a name which broker is listening, create that DSN.
the problem will be solved. |
|
| Back to top |
|
|
|
|
