connecting IDS on different machines
Hi all, I want to access different databases on different machines. Is this possible? I read long time ago something about this but I can't remember me. Damm!! I thought it was something about mentionning both machines in the sqlhost file... Thanks for any help!! I have. IDS 9.40 SuSe
2009/11/17 DANNY DE KOSTER <ddk@fidelity-soft.be>: > Hi all, > > I want to access different databases on different machines. Is this possible? > I read long time ago something about this but I can't remember me. Damm!! > > I thought it was something about mentionning both machines in the sqlhost > file... > Thanks for any help!! > > I have. > IDS 9.40 > SuSe > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Danny You are correct, provided you have a TCP connection to the remote database engine defined in the config file then putting an entry in the local sqlhosts file and in the local /etc/services file will enable connectivity. Keith
Yes, all of the servers you want to access must be in the sqlhosts file.
Once that's done, you can access a remote server directly by setting
INFORMIXSERVER to that servername or by specifying it in the connect string:
CONNECT TO 'remotedatabase@someotherserver';
or
CONNECT TO '@someotherserver';
DATABASE 'remotedatabase';
or you can connect through the local server for remote joins:
SELECT * FROM localtable, remotedatabase@someotherserver:remotetable ....
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Tue, Nov 17, 2009 at 3:44 AM, DANNY DE KOSTER <ddk@fidelity-soft.be>wrote:
> Hi all,
>
> I want to access different databases on different machines. Is this
> possible?
> I read long time ago something about this but I can't remember me. Damm!!
>
> I thought it was something about mentionning both machines in the sqlhost
> file...
> Thanks for any help!!
>
> I have.
> IDS 9.40
> SuSe
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0023545bdb80c415cf0478927157