Kbase P42510: How to connect through system DSN without being prompted for user & password ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
How to connect through system DSN without being prompted for user & password ?
GOAL:
Is it possible to suppress logon dialog from system DSN of ODBC Admin?
GOAL:
Is it possible to suppress logon dialog for WinSQL?
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FIX:
As per following DataDirect KB entry you must use SQL_DRIVER_NOPROMPT and function SQLConnect in order to suppress logon dialog.
You won't be able to achieve this with for example: WinSQL, ODBCAdmin or/and MSQuery as these are using SQLDriverConnect. For example Cognos application uses SQLConnect.