The driver supports User ID and password authentication. It authenticates the user to the database using a user name and password.

To configure the driver to use user ID and password authentication:
  • Set the Host Name (HostName) option to specify the name or the IP address of the server to which you want to connect.
  • Set the Database Name (Database) option to specify the name of the database to which you want to connect by default.
  • Set the Port Number (PortNumber) option to specify the port number of your server listener. For example, 20931.
  • Set the User Name (LogonID) option to specify the user name for your Progress OpenEdge server.
  • Set the Password option to specify the password for your Progress OpenEdge server.

The following examples show the connection information required to establish a connection using user ID and password authentication.

Connection string

DRIVER=DataDirect 8.0 Progress OpenEdge Wire Protocol;HostName=MyOpenEdgeServer;
       PortNumber=20931;Database=MyDatabase;LogonID=jsmith;Password=secret;

odbc.ini

[Progress OpenEdge]
Driver=ODBCHOME/lib/xxoe28.yy
...
Database=MyDatabase
...
HostName=MyOpenEdgeServer;
...
LogonID=jsmith
...
Password=secret
...
PortNumber=20931
...
Note: The LogonID and Password options are not required to be stored in the data source. They can also be sent separately by the application using the SQLConnect ODBC API. For SQLDriverConnect and SQLBrowseConnect, they will need to be specified in the data source or connection string.