Re: How To connect to remote database in Online 7.1
Raj,
You don't mention what version of Online you are running. If
it's 5.X then just start the sqlexecd daemon with the -l log option.
This option will log all attempts. What you'll probably notice
is that the host you have listed in the sqlhosts file of "level3"
will be listed in the log file either in uppercase or as
"level3.xxx.xxx". Then just change the entry in the sqlhosts file
to match. Once you get it working, stop/start the sqlexecd daemon
without the log option. That logfile can grow quickly!
If it's version 6 or higher, then run the command "nslookup" on level3.
The name that comes back, is what you should either change
the entry in the sqlhosts to be, or add an alias in the /etc/hosts
file to match it for level3.
Good Luck!
Tracy
=========================================================================
= Tracy W. Nedd =
= Banctec Inc. - DBA =
= Silver Spring, Md =
= tracyn@asd.banctec.com =
=========================================================================
= ALL RIGHTS RESERVED. =
= This posting is copyright and may be used only for the purposes =
= of professional study, or the professional exchange of information. =
= Use of this posting by any commercial organization for the purposes =
= of vilifying another is explicitly prohibited. =
=========================================================================
}
} Informix Experts,
}
} We are having a problem connecting to a remote database. The sqlhosts
} file on the client station looks like
}
} level3 onsoctcp level3 wideworld
}
} and the /etc/services file looks like
}
} wideworld 1556/tcp
}
} The sqlhosts file on the server is
}
} level3 onipcshm level3 level3
} level3 onsoctcp level3 wideworld
}
} and the /etc/services file is
}
} wideworld 1556/tcp
}
} Now when we try to dbaccess from the client, it tries to connect for a
} while, and then comes with an error 908 (cannot connect, server down or
} network down etc). We can dbaccess locally on the server. There is no
} oninit running on the client.
}
} What are we doing wrong here?
}
} Any and all help on this matter appreciated.
}
} Thanx,
}
} Raj.
}