Database connections

  • Support for single or double quotes   Values in connection strings can now be enclosed in single or double quotes. This allows characters such as spaces and semicolons to be used in connection string values. See Connection parameters passed as connection strings.

  • Connection strings now allow T, Y, F, and N as boolean values   You can now specify T or Y to indicate true, and F or N to indicate false, when specifying connection parameters and protocol options in connection strings. See Connection parameters.

  • Some connection strings and protocol options now accept values with k, m, and g suffixes   The following connection parameters and protocol options now accept k, m, and g as suffixes indicating kilobytes, megabytes, and gigabytes, respectively:

  • AppInfo returns IP address for Windows clients   In previous releases, the AppInfo connection parameter only returned the IP address of the client computer on Unix and NetWare clients. The IP address is now returned for Windows clients as well. See AppInfo (APP) connection parameter.

  • Auditing individual connections   The conn_auditing temporary database option allows you to enable or disable auditing for a specific connection when the option is set in a login procedure. The auditing database property has been added to help you obtain information about the auditing status of a database. See conn_auditing option.

  • RetryConnectionTimeout connection parameter   The RetryConnectionTimeout (RetryConnTO) connection parameter tells the client library to retry the connection attempt, as long as the server is not found, for the specified period of time. See RetryConnectionTimeout (RetryConnTO) connection parameter.

  • Support for IPv6   IPv6 is supported now on Windows, Linux, Mac OS X, Solaris, AIX, and HP-UX. Servers running on these operating systems now listen on all available IPv4 and IPv6 addresses, and anywhere you can specify an IP address on the client or server (such as the HOST=, MYIP=, and BROADCAST= TCP protocol options), you can now specify an IPv6 address. See IPv6 support in SQL Anywhere.

  • New parameters for LDAP registration   The read_authdn and read_password parameters can be used to register the database server with LDAP if the database server is an Active Directory server. See Connecting using an LDAP server.