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.

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 PostgreSQL Wire Protocol;HostName=myserver;PortNumber=5432;
Database=MyDB;LogonID=John;Password=secret

odbc.ini

[PostgreSQL Wire Protocol]
Driver=ODBCHOME/lib/xxpsql28.yy
...
HostName=myserver
...
PortNumber=5432
...
Database=MyDB
...
LogonID=John
...
Password=secret
...