User ID/password authentication

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

Note that the driver supports the SCRAM-SHA-256 hashing mechanism for user ID/password authentication. During connection, the driver determines whether to send the password in hashed form or clear text based on the server settings.

To configure the driver to use user ID/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 Port Number (PortNumber) option to specify the port number of the server listener. The default is 5432.
• Set the Database Name (Database) option to specify the name of the database to which you want to connect.
• Set the User Name (LogonID) option to specify your user name.
• Set the Password option to specify your password.

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

Connection string

DRIVER=DataDirect 8.0 Greenplum Wire Protocol;HostName=myserver;PortNumber=5432;
Database=Payroll;LogonID=John;Password=secret

odbc.ini

[Greenplum Wire Protocol]
Driver=ODBCHOME/lib/xxgplm28.yy
...
HostName=myserver
...
PortNumber=5432
...
Database=Payroll
...
LogonID=John
...
Password=secret
...