Author |
Message
|
anupama |
Posted: Wed May 14, 2008 2:05 am Post subject: HOW TO CONNECT DATABASE |
|
|
Novice
Joined: 03 Apr 2008 Posts: 19
|
HI
How to connect multiple databases(orale,DB2,sybase) at atime through ESQL... |
|
Back to top |
|
 |
fjb_saper |
Posted: Wed May 14, 2008 2:08 am Post subject: |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
|
IIRC from within the same node you can only connect to multiple DBs of the same TYPE (DB2, Oracle, Sybase, MSSQL,...).
Enjoy  _________________ MQ & Broker admin |
|
Back to top |
|
 |
anupama |
Posted: Wed May 14, 2008 3:06 am Post subject: HOW TO CONNECT DATABASE |
|
|
Novice
Joined: 03 Apr 2008 Posts: 19
|
Hi saper
I am new to this so can u explai more clearly.......
what is IIRC,I didnt get it properly.....i am MessageBroker 5.0...is it possible here any way thanks..... |
|
Back to top |
|
 |
Vitor |
Posted: Wed May 14, 2008 3:24 am Post subject: Re: HOW TO CONNECT DATABASE |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
anupama wrote: |
I am new to this so can u explai more clearly....... |
How much more clearly than "you can only connect to multiple databases of the same type do you want"?
anupama wrote: |
what is IIRC, |
IIRC = If I Remember Correctly
In this case he does. _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
Gaya3 |
Posted: Wed May 14, 2008 3:24 am Post subject: |
|
|
 Jedi
Joined: 12 Sep 2006 Posts: 2493 Location: Boston, US
|
MB V5, you cant able to connect multiple database(in the sense you can connect to one database type, not to different database type) through ESQL.
So upgrade to MB V6/6.1: Where you can do
Regards
Gayathri _________________ Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
Back to top |
|
 |
anupama |
Posted: Thu May 15, 2008 12:06 am Post subject: How to connect to database |
|
|
Novice
Joined: 03 Apr 2008 Posts: 19
|
Thanks gayatri
Now i got an idea,ok in v6 how you connect mutliple database(in the sence only one type database).............. |
|
Back to top |
|
 |
Vitor |
Posted: Thu May 15, 2008 12:08 am Post subject: Re: How to connect to database |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
anupama wrote: |
Now i got an idea,ok in v6 how you connect mutliple database(in the sence only one type database).............. |
How does the documentation suggest you define multiple datasources?
 _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
|