Re: Remote connections..
Posted in 2001
At 22:08 01/01/16 +0000, Prasad Mahale wrote:
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.
>
>
>
--
$B0KF#Ci%F%/%N%5%$%(%s%93t<02q<R(B
INFORMIX$B1D6H?d?JIt(B $B2.86!!6P(B
Tsutomu.Ogiwara@ctc-g.co.jp/ifmx-tech@ctc-g.co.jp
102-0074 $BEl5~ET@iBeED6h6eCJFn(B2-3-14
TEL.03-5212-4880 FAX.03-5212-4889