When to set the PGDBE client license for an application?

[Pat France]

There are basically two preconditions for an application to be able to successfully establish a connection to a PostgreSQL database:

• The PGDBE must be loaded using DbeLoad()
• On a non-developer machine, a client license must be specified for connecting to the PostgreSQL server. *)

*) Note that on a developer machine, the active development tool license is automatically detected, hence no dedicated PostgreSQL client license is required

These preconditions are deemed critical, because if they are not met, the application will not be able to use or connect to the PostgreSQL server. It is therefore recommended to perform these two steps together, either in the DbeSys() procedure, or in another code location guaranteed to be executed before the first connection attempt is made.

//
// Load PGDBE and set it up for accepting connections
//

DbeLoad( "PGDBE" )

// Ensure PGDBE is the default DBE, as DbeInfo() always operates on the default DBE
DbeSetDefault( "PGDBE" )

// Set license key and licensee for the DBE and therefore for all future connections
DbeInfo( COMPONENT_DICTIONARY, PGDIC_LICENSE, "licensekey=<your-license-key>;licensee=<your-licensee-name>;")