Kbase P98332: Unix client is unable to make SQL-92 connection to database, getting Invalid host name in connect st
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/1/2004 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
UNIX client is unable to make SQL-92 connection to database.
SQLConnect: Failed
SQLSTATE = 60
NATIVE ERROR = -20215
MSG = [DataDirect-Technologies][ODBC 20101 driver][20101]Invalid host name in connect string.
sqlexp works fine.
ODBC connections from a Windows Client works fine.
CAUSE:
ODBC.INI file Hostname entry has a space at the end of the line which is not a valid character for a host name.
FIX:
Remove spaces from the end of the Hostname entry in the ODBC.INI file.