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 Network Address (NetworkAddress) option to specify the unique identifier assigned to the Sybase IQ server machine.
  • 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 connection using user ID and password authentication.

Connection string

DRIVER=DataDirect 8.0 Sybase IQ Wire Protocol;NetworkAddress=123.456.78.90, 2638;
Database=payroll;LogonID=jsmith;Password=secret;

odbc.ini

[Sybase IQ]
Driver=ODBCHOME/lib/xxsyiq28.yy
...
NetworkAddress=123.456.78.90, 2638
...
Database=payroll
...
LogonID=jsmith
...
Password=secret
...
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.