Authentication

The driver supports 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 IP address or the host name of the computer that is running the database server to which you want to connect.
• Set the Port Number (PortNumber) option to specify the port number of the server listener.
• Set the Server Name (ServerName) option to specify the name of the database 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.
• 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 Informix Wire Protocol;HostName=myserver;PortNumber=4321;
ServerName=Acct;Database=Payroll;LogonID=John;Password=secret

odbc.ini

[Informix]
Driver=ODBCHOME/lib/xxifcl28.yy
...
HostName=myserver
...
PortNumber=4321
...
ServerName=Acct
...
Database=Payroll
...
LogonID=John
...
Password=secret
...