Kbase P68059: Where is stored the connection information to a non-Progress database using DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/10/2004 |
|
Status: Unverified
GOAL:
Where is stored the connection information to a non-Progress database using DataServer
GOAL:
Where can the connection parameters to a foreign data source be retrieved
FACT(s) (Environment):
Oracle DataServer
FACT(s) (Environment):
MS SQL Server DataServer
FACT(s) (Environment):
ODBC DataServer
FIX:
Progress stores all connection information to the foreign data source within the schema holder. The -U and -P connection parameters are the userId and Password that are used to connect to the foreign data source.
There are 2 ways to retrieve the connection parameters:
- Review the connection parameters by going into
Data Administration Menu, DataServer, MS SQL Server/ODBC/Oracle Utilities, Edit Connection Information.
Please note that this stored information can be overwritten if user decides to define new connection parameters manually.
OR
- Run the following piece of code against the _db table:
FOR EACH _db:
DISPLAY _db-comm.
END.