| Author |
Message
|
| Siddu |
 Posted: Mon Sep 03, 2012 2:14 am Post subject: Connecting to Database SQL Server Using ESQL |
 |
|
Apprentice
Joined: 22 Aug 2012
Posts: 44
|
Hi,
I'm newbie to WMB.
I'm trying to connect to SQL server using ESQL.
Could someone guide me on how to connect?
(It's not Oracle. I'm connecting using Key based User Authentication)
 |
|
| Back to top |
|
 |
| Vitor |
| Posted: Mon Sep 03, 2012 3:34 am Post subject: Re: Connecting to Database SQL Server Using ESQL |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Siddu wrote: |
| Could someone guide me on how to connect? |
You create a data source for the broker to use.
You associate your ESQL with that data source.
You write your ESQL.
 and come back if you back specific problems.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon Sep 03, 2012 4:15 am Post subject: Re: Connecting to Database SQL Server Using ESQL |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Siddu wrote: |
(It's not Oracle. I'm connecting using Key based User Authentication)
|
Is this mysterious DB on the list of supported databases? The list is in the InfoCentre.
_________________
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 |
|
|
| mona |
| Posted: Sun Sep 09, 2012 5:23 am Post subject: |
|
|
Novice
Joined: 14 Mar 2012
Posts: 19
|
Hi
1- Create Data source
2- in property compute node we set Datasource and Transation = cmmite
3- create database definaition
4- write ESQL code for use DB in compute node
5- use mqsisetdbparms broker name -n Datasource name -u userID -p password
6- mqsicvp broker name -n Datasource name |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sun Sep 09, 2012 11:03 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| mona wrote: |
Hi
1- Create Data source
2- in property compute node we set Datasource and Transation = cmmite
3- create database definaition
4- write ESQL code for use DB in compute node
5- use mqsisetdbparms broker name -n Datasource name -u userID -p password
6- mqsicvp broker name -n Datasource name |
not a bad list of things to do but as Eric Morecambe famously once said to the conductor Andre Previn, "I'm playing all the right notes but not neccessecarily in the right order".
I'd probably do them in this order
1,5,6. Then is that is all ok then do 2 & 4
I'm not sure what you mean by 3 (does the DB exist already?) If it does not then you have to do that first...
_________________
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: Sun Sep 09, 2012 11:53 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| smdavies99 wrote: |
| I'm not sure what you mean by 3 (does the DB exist already?) If it does not then you have to do that first... |
He means the definition in Toolkit to allow for things like mapping nodes to know what the database looks like, and for certain kinds of toolkit warnings to go away. |
|
| Back to top |
|
|
| Siddu |
| Posted: Mon Sep 10, 2012 3:52 am Post subject: |
|
|
Apprentice
Joined: 22 Aug 2012
Posts: 44
|
| mona wrote: |
Hi
1- Create Data source
2- in property compute node we set Datasource and Transation = cmmite
3- create database definaition
4- write ESQL code for use DB in compute node
5- use mqsisetdbparms broker name -n Datasource name -u userID -p password
6- mqsicvp broker name -n Datasource name |
Thank You  |
|
| Back to top |
|
|
|
|
