Re: Remote connections..
Posted in 2001
At 22:08 01/01/16 +0000, Prasad Mahale wrote:
Send again.
My signature is Japanese.
Sorry...
Hi Prasad.
Here is my environment.
INFORMIXSERVER=iif921uc1
% cat ~/.rhostsifmx28
localhost
% cat $INFORMIXDIR/etc/sqlhosts(INFORMIXSERVER=iif921uc1)iif921uc1 ontlitcp ifmx28 iif921uc1_1
iif921uc12 ontlitcp ifmx28 iif921uc1_12
iif921uc13 ontlitcp ifmx28 iif921uc1_13
iif920uc41 ontlitcp ifmx28 iif920uc4_1
% cat sqlhosts(INFORMIXSERVER=iif920uc41)iif920uc41 ontlitcp ifmx28 iif920uc4_1
iif921uc1 ontlitcp ifmx28 iif921uc1_1
Run dbaccess as follows
DBACCESS: Query-language Connection Database Table Session Exit
Use SQL query language.
Select ConnectionCONNECTION: Connect Disconnect Exit
Connect to a database environment.
Select ConnectSELECT DATABASE SERVER >>
Select a server with the Arrow Keys, or enter a name, then press Return.
------------------------------------------------ Press CTRL-W for Help --------
iif920uc41
iif921uc1
Select iif920uc41USER NAME >>
Enter the login name you want to use for this connection.
Enter USERNAME
PASSWORD >>
Enter the password associated with the user identifier.
Enter password
SELECT DATABASE >>
Select a database with the Arrow Keys, or enter a name, then press Return.
----------------------- @iif920uc41 ------------ Press CTRL-W for Help --------
ogi@iif920uc41
stores_demo@iif920uc41
Regards.
>Hi All,
>Here is my question.
>
>I have two databases on two different unix boxes. I am trying to connect
>database B from database A (from dbaccess). As soon as i select CONNECT
>option and enter login and passward for server B, it immediately says
>'Disconnected' and waits there for about 3/4 minutes and then returns error
>908 ( Attempt to connect to database server (xyz) failed ). The entries in
>sqlhosts (It's a tlitcp connection), /etc/services and /etc/hosts looks
>perfect and i am able to connect these servers using telnet either way.
>
>Its IDS 7.31 on Sun 5.7.
>
>What could be the problem?
>
>Thanks in advance
>
>prasad
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
>
--
Tsutomu Ogiwara
Technical Group & Red Brick Group, Informix Sales Promotion Dept
CTC, ITOCHU Techno-Science Corporation
Yasukuni Kudan-Minami Bldg., 2-3-14, Kudan-Minami Chiyoda-Ku TOKYO,
102-0074 JAPAN
Phone:+81-3-5212-4891 Fax:+81-3-5212-4889
E-mail:Tsutomu.Ogiwara@ctc-g.co.jp / tsutoo@my-deja.com