Database Connection Strings

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

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!