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 relatedsource ./openlink.sh csh, tcsh
and relatedsource ./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.
- If ODBCINI is set, re-test your connection.
- 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.
- Locate your DSN.
For example: