When you use the Host parameter, no UDP packets are sent if enough information is given to uniquely identify the server (a host name and a port number). The new Host connection parameter takes a host name (or an IP address) and an optional port number that tells the client where to find the database server. They are used to specify the host and the port attributes of the connection. Two new connectivity options are available with the SQL Anywhere version 12. Server name: Enter the name of the database server you want to connect to.
How to trace sql anywhere client to database driver#
The following table lists the data types that are supported by version 12 of the iAnywhere driver along with their SQL and DBX correspondents: If the described byte length in the client character set for the NCHAR, NVARCHAR, CHAR, or VARCHAR data type with character length semantics would be more than 32767, then these types are described as the LONG NVARCHAR or LONG VARCHAR data type. The CHAR, NCHAR, NVARCHAR, and VARCHAR data types now support 32768 characters length values. A TIMESTAMP WITH TIME ZONE value requires ten bytes of storage. The fraction is stored to six decimal places. TIMESTAMP WITH TIME ZONE contains the year, month, day, hour, minute, second, fraction of a second, and number of minutes before or after the Coordinated Universal Time (UTC). The new TIMESTAMP WITH TIME ZONE data type stores a point in time with a time zone offset.