| Author |
Message
|
| HemavathyRG |
 Posted: Fri Apr 22, 2016 1:42 am Post subject: how to send array to th estored procedure using ESQL. |
 |
|
Newbie
Joined: 20 Apr 2016
Posts: 8
|
I am using ESQL to send the array to SP.
And I ended up in getting the below exception.
Can any one suggest how to resolve this please.
BIP2322E:Child SQL exception:IM002:0:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Fri Apr 22, 2016 2:01 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
If you search this site you will find many similar posts.
Have you read any of them?
Seard for something like
| Code: |
| stored procedure array |
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Apr 22, 2016 4:02 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
What does 'Data Source not found" mean?
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| HemavathyRG |
| Posted: Fri Apr 22, 2016 5:26 am Post subject: |
|
|
Newbie
Joined: 20 Apr 2016
Posts: 8
|
|
| Back to top |
|
|
| manoj5007 |
| Posted: Tue Apr 26, 2016 8:53 am Post subject: |
|
|
Acolyte
Joined: 15 May 2013
Posts: 64
|
| Have you given the datasource name (DSN) in the appropriate Compute or database node whichever node you are calling the stored procedure from? |
|
| Back to top |
|
|
| ruiduarte22 |
| Posted: Wed Apr 27, 2016 4:35 am Post subject: |
|
|
Newbie
Joined: 01 Apr 2016
Posts: 7
|
| You probably are not defining the Data Source property in compute Node |
|
| Back to top |
|
|
|
|
