Kbase P102609: Where is ODBC DSN name stored in schema holder ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/01/2009 |
|
Status: Verified
GOAL:
Where is ODBC DSN name stored in schema holder?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
The ODBC DSN name is stored in _db._db-addr field in the schema holder.
There should be at least two _db records. Dataserver schema is the _db
record with _db-type = "ODBC" or "MSS" depending which dataserver product is used.
Sample code:
FOR EACH _db WHERE _db-type = "ODBC" NO-LOCK :
DISPLAY _db._db-addr _db._db-name.
END.