| Author |
Message
|
| aravind703 |
 Posted: Tue May 15, 2012 7:12 am Post subject: Microsoft SQL Server and Sybase in Single Database |
 |
|
Apprentice
Joined: 24 Sep 2011
Posts: 29
|
Hi,
Is there a way where I can connect to Microsoft [SQL Server(Database) and Sybase (Database) in one compute node. I am able to connect to these 2 databases separately with 2 compute nodes. I was wondering if there is a way to connect using one compute node.
I did some research in this forum , google and found that we can connect to 2 different databases of same kind ( 2 sybase or 2 Sql Servers) in one compute node. I might have missed something, what I am trying to accomplish is to connect to Sybase database and Microsoft SQL server data base in one compute node any sort of inputs are highly appreciated.
Thanks |
|
| Back to top |
|
 |
| Vitor |
| Posted: Tue May 15, 2012 7:18 am Post subject: Re: Microsoft SQL Server and Sybase in Single Database |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| aravind703 wrote: |
| any sort of inputs are highly appreciated. |
Your research is accurate. You can't mix database types in a single Compute node.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue May 15, 2012 7:22 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
It shouldn't be necessary to do this.
What is the business requirement to do this in one compute node vs. two? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue May 15, 2012 7:38 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Since MS SQLServer and Sybase SQLServer can communicate betwixt themselves (ie. they use the same basic protocol), technically, you can send traffic to one which has an external reference via stored proc to the other.
However, mqjeff and Vitor both have very good points. There is seemingly no business reason why this is a good idea.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue May 15, 2012 7:47 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| And if you can demonstrate a good enough reason, I'll tell you how to do it. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue May 15, 2012 8:13 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| And if you can demonstrate a good enough reason, I'll tell you how to do it. |
Do you mean that?
Is it wise? It's like showing a 4 year old a faster way to load a gun, or getting me to re-wire your house.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
