Kbase P108418: How to control the behavior of the Data Direct SQL-92 login dialog box
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/02/2009 |
|
Status: Verified
GOAL:
How to control the behavior of the Data Direct SQL-92 login dialog box
GOAL:
How to prevent the appearance of DataDirect's SQL-92 login dialog box when making an ODBC connection
GOAL:
How to automate the ODBC login to a Progress database
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The options an application can use to control the login dialog box when doing a SQLDriverConnect to SQL Server:
1) Using SQL_DRIVER_COMPLETE, you must pass the DSN, UID, PWD, and SRVR in the InConnectionString.
2) Using SQL_DRIVER_NOPROMPT, you must pass the DSN and PWD (at minimal) and provide the UID and SRVR in the datasource.
3) Using SQLConnect instead of SQLDriverConnect, you are never prompted.
If you are using SQL_DRIVER_PROMPT, the user is prompted, even if all the connection information is provided.
If you are using a vendor application, contact the vendor to find out how to modify the connection options.