The driver supports User ID/password authentication. It authenticates the user to the database using a user name and password.
Important: The procedure given in this section uses the user ID/password authentication without encryption. To use it with encryption, set the Authentication Method option to 1 (Encrypt Password). See "Authentication Method" for details.

To configure the driver to use user ID/password (no encryption) authentication:

  • Set the Network Address (NetworkAddress) option to specify the unique identifier assigned to the SAP ASE 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 SAP ASE Wire Protocol;NetworkAddress=123.456.78.90, 5000;
       Database=payroll;LogonID=jsmith;Password=secret;

odbc.ini

[SAP ASE]
Driver=ODBCHOME/lib/xxase28.yy
...
NetworkAddress=123.456.78.90, 5000
...
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.