| Author |
Message
|
| aradha |
 Posted: Thu Feb 04, 2010 5:45 am Post subject: Database connection |
 |
|
Apprentice
Joined: 16 Dec 2008
Posts: 45
|
Hi
I connected to dadabase(DB2) through ESQL by using the Database node
by defining the database node properties i.e Datasource name.
But now trying to connect multiple database, here i stucked
If anybody handled such kind i.e how to connect multiple database through ESQL kindly let us know.
 |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Feb 04, 2010 5:53 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You can not connect to two different kinds of databases from the same compute node.
So you can't connect to Oracle DSN and DB2 DSN inside the same Compute node, you need two compute nodes. |
|
| Back to top |
|
|
| aradha |
| Posted: Thu Feb 04, 2010 6:17 am Post subject: Database connection |
|
|
Apprentice
Joined: 16 Dec 2008
Posts: 45
|
Hi
But if you want to connect multiple database connection means
which option I have to prefer any more help???? |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Feb 04, 2010 6:21 am Post subject: Re: Database connection |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| aradha wrote: |
| which option I have to prefer any more help???? |
Contact IBM, raise a product enhancement request to allow this kind of connection. The more people who ask for it, the more likely it is to be added to the product.
In the short term though, you need 2 Compute nodes. Or migrate all your databases to one common platform. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Feb 04, 2010 6:24 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Unless by "connect to multiple databases" you actually mean "connect to more than 1 DB2 database" or "more than 1 Oracle database" in which case you need to post what you've tried and the error message you got.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| aradha |
| Posted: Thu Feb 04, 2010 6:30 am Post subject: Database connection |
|
|
Apprentice
Joined: 16 Dec 2008
Posts: 45
|
| Is there any option through ESQL to connect the multiple databases???? |
|
| Back to top |
|
|
| aradha |
| Posted: Thu Feb 04, 2010 6:34 am Post subject: Database connection |
|
|
Apprentice
Joined: 16 Dec 2008
Posts: 45
|
Hi vitor
I want to know "connect to more than 1 DB2 database" and "more than 1 Oracle database" becoz this is the first time i am trying to connect to database,happy to feel if you can explain both for us...................... |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Feb 04, 2010 7:49 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
A Compute node can connect to Multiple Databases BUT these databases MUST be of the same type.
All Db2
All ORacle
All SQL Server
etc.
If you want to mix DB types then as Vitor says, you need to use multiple Comput nodes.
_________________
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 |
|
|
| aradha |
| Posted: Thu Feb 04, 2010 9:13 am Post subject: |
|
|
Apprentice
Joined: 16 Dec 2008
Posts: 45
|
Hi smdavies
Can you explain us any sample for
A Compute node can connect to Multiple Databases ,i.e to connect all DB2 or Oracle etc. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Feb 04, 2010 9:44 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Aradha -
Please Try Harder. What you are asking is directly documented.
You can specify a DSN in your ESQL code. This can be different than the DSN you specified on the Compute node properties.
But both DSNs must point to the same type of DBMS, i.e. they all must be Oracle 10 or DB2 v9 or Informix 8 or SQLServer 2008.
Go search the documentation for this. Read it several times. Test it out yourself. Think about what it means. Read it again.
If you have failed to solve this basic issue AFTER all of that, then come back and post SPECIFICS about EXACTLY what you have done. |
|
| Back to top |
|
|
|
|
