Consultor Eletrônico



Kbase P75253: How to define multiple database connections with the DATABASES environment variable in WebSpeed?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   30/09/2008
Status: Verified

GOAL:

How to define multiple database connections with the DATABASES environment variable in WebSpeed?

GOAL:

How to set multiple database connections with the DATABASES environment variable in WebSpeed?

GOAL:

How to connect to multiple databases when setting the DATABASES environment variable within WebSpeed?

FACT(s) (Environment):

WebSpeed 3.1D
OpenEdge 10.x
All Supported Operating Systems

FIX:

Example, you have 2 databases that the client will connect to

database 1 -> sports2000
database 2 -> pscdemo

When connecting to multiple databases, you must separate each database connection using the PIPE symbol.

For example;
Databases=sports2000=sportsconnect.p|pscdemo=-pf c:/databases/pscdemo.pf

Remember it is possible to associate specific program-code (.p) with specific databases or connection parameters (.pf). Please note that by specifying a program and adding logic to a custom ?end-request? procedure, you can even perform logic driven database connections.