Kbase P99801: Connecting to Progress via SQL-92 SERVER encounters error "INSUFFICIENT INFORMATION TO CONNECT"
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/10/2008 |
|
Status: Verified
SYMPTOM(s):
Connecting to Progress via SQL-92 SERVER encounters error "INSUFFICIENT INFORMATION TO CONNECT"
Attempting to connect to Progress via SQL-92 SERVER encounters Insufficient Information error
Error insufficient information to connect to the database.
ERROR DESCRIPTION: [MERANT][Progress ODBC] INSUFFICIENT INFORMATION TO CONNECT
TO DATA SOURCE.
FACT(s) (Environment):
Connecting via third party application
Database security is not enabled.
Connection via SQL Explorer works.
Connection via WinSql works.
MERANT 3.60 32-BIT Progress SQL-92
Windows
Progress 9.x
OpenEdge 10.1x
CAUSE:
Connection information when using third party application did not include a password.
SQL-92 connection information must include -uid (userid) and -pwd (password) even if not required by the database.
FIX:
Add -pwd (password) connection parameter and value to the connection string.