Kbase 22076: How To Grab DB Connection Parameters from Within the Session
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/06/2002 |
|
SUMMARY:
This Solution applies to Progress 8.x and 9.x. It provides information on accessing database connection parameters from within the Progress session.
EXPLANATION:
Information about database connections within a Progress session is stored in the _db table.
The correspondence between _db fields and client startup parameters is as follows:
_db-name = -ld ( logical name )
_db-addr = -db ( physical name )
_db-type = -dt ( database type )
_db-slave = indicates whether it is schema holder or not; when using
DataServer( NO = schema holder, YES = DataServer schema )
_db-local = remote or local database connection
_db-conn = stores all the database connection parameters for a
particular database
NOTE: When using SQL/ODBC Dataservers, the DSN could be found in the
_db-addr field unless it is specified with the -Dsrv parameter. In that case the information has to be extracted from _db-comm field.