Database Connection Strings

Attention: This feature is in Early Adopter Program (EAP) release status. We will continue the development of additional features and provide additional interfaces via patch updates and future releases. Please contact Micro Focus SupportLine if you require further clarification.

Use the following syntax when making a direct connection with the different types of supported databases (as opposed to using an ODBC DSN). These strings are used in the database configuration file and in Enterprise Server.

Microsoft SQL Server (including Azure SQL Database)

Syntax:

Driver={SQL Server Native Client 11.0};<connection-options>

or

Driver={ODBC Driver 13 for SQL Server};<connection-options>

Example:

Driver={ODBC Driver 13 for SQL Server};Server=localhost\SQLEXPRESS;Database=MicroFocus$SEE$Files$VSAM;Trusted_Connection=yes

PostgreSQL

Syntax:

Driver={PostgreSQL ANSI};<connection-options>

Example:

Driver={PostgreSQL ANSI};Server=localhost;Port=5432;Database=MicroFocus$SEE$Files$VSAM;Uid=mfdbfh;Pwd=MfdbfhAdmin1!;

Db2 (preferred)

Syntax:

db=<database/alias name;>;uid=<user name>;pwd=<password>

Note: This is the preferred format to be used. The Hostname, Port, and Protocol will typically have been cataloged for the node associated with the specified database/alias name.

Example:

db=VSAM;uid=mfdbfh;pwd=dbfhAdmin1!

Db2

Syntax:

Driver={IBM DB2 ODBC DRIVER};<connection-options>

Example:

Driver={IBM DB2 ODBC DRIVER};Database=VSAM;Hostname=localhost;Port=50000;Protocol=TCPIP;uid=mfdbfh;pwd=dbfhAdmin1!