ODBC data storage settings

Table: ODBC data storage settings
Field name Description
Display Name This the name that will be displayed in the ODBC Data Sources list.
DSN The ODBC data source name used to connect to the specified database.
User Name User credentials used to connect to the specified database.
Password The password used to connect to the specified database.
Min Reconnect Interval The minimum time (in seconds) that OneSpan Authentication Server should wait to reconnect to this data source.
Max Reconnect Interval Enter the maximum time (in seconds) that OneSpan Authentication Server should wait before retrying the connection.
Connection Management
Max Connections The maximum number of connections, which OneSpan Authentication Server should make to the database at the same time.
Idle Timeout (seconds) The period (in seconds) before unused connections to the database should be closed by OneSpan Authentication Server.
User ID Conversion
Case

The character casing that OneSpan Authentication Server will use to save and retrieve user IDs in.

Possible values:

  • Convert to Lower-case. Use this to handle user IDs in lowercase.
  • No Conversion. Just save and retrieve using the user ID as it was entered.
Field name Description
Advanced Settings
Connection Wait Time (ms)

When OneSpan Authentication Server already has the maximum number of database connections open and a new request arrives, OneSpan Authentication Server will wait for a database connection to become available (unless the Enable Load Sharing option is used). The Connection Wait Time value specifies this waiting period.

If the database does not respond within the connection wait time, OneSpan Authentication Server will report a timeout on that database. OneSpan Authentication Server will then attempt to connect to the next available database (if any). If OneSpan Authentication Server reports a timeout on all available databases, then it will report a timeout on the authentication request.

However, if the database rejects the connection before the connection wait time expires, OneSpan Authentication Server will wait for the connection wait time to pass before retrying a connection to the same database.

If load sharing is enabled, OneSpan Authentication Server will immediately attempt to connect to the next available database if its connection attempt was refused or if the connection wait time expires.
Enable Load Sharing Select this checkbox if you have multiple databases and want the OneSpan Authentication Server service to switch to another database when it exceeds the connection limit or if the current database becomes unavailable.