Error Message: Unknown Host
The "unknown host" error message suggests environment or hostname resolution problems.
If you receive such errors, take the following action:
- Navigate to the root directory of your OpenLink client installation.
- Set the OpenLink environment by running the appropriate script for your shell.
The following will work in most environments, but your required command may differ --
shell | command |
---|
sh, bash, zsh and related | . ./openlink.sh |
ksh and related | source ./openlink.sh |
csh, tcsh and related | source ./openlink.csh |
- Run the following command:
echo $ODBCINI
- If ODBCINI is set, re-test your connection.
- If ODBCINI is not set, continue with the steps below.
- cd into the root directory of your OpenLink client installation.
- Open openlink.sh or openlink.csh (whichever you ran above) in a text editor.
- Record the variable settings found there, and close the file.
- Set all the variables on your command line.
For example:
export ODBCINI=/usr/openlink/bin/odbc.ini
export ODBCINSTINI=/usr/openlink/bin/odbcinst.ini
export UDBCINI=/usr/openlink/bin/udbc.ini
- Test your connection.
- If the problem persists, open your odbc.ini file.
You will find this file in the /bin sub-directory of your client's OpenLink installation.
- Locate your DSN.
For example:
[OpenLink]
Driver = /usr/openlink/lib/oplodbc.sl.1
Description = Sample OpenLink DSN
Host = broker-host.example.com
Port = 5000
ServerType = SQLServer 7
FetchBufferSize = 99
UserName = sa
Password =
Database = Northwind
- Change the Host value from a FQDN (fully-qualified domain name), to the IP address of the target host.
For example:
Host = 10.10.10.10
- Save your changes and test once more.