Database Connections

Database connections enhancements were made in Sybase IQ 15.4.

• Temporary connections are named – Temporary connections are used to perform operations such as running backups or initializing databases. You can get information about temporary connections by using the sa_conn_info system procedure, the sa_conn_list system procedure and the Name and ParentConnection connection properties.

  Objects, Properties, and Procedures

  Object / Property Name	Description
  Temporary connections	Perform operations such as running backups or initializing databases. For more information, see SQL Anywhere Server - Database Administration > Starting and connecting to your database > SQL Anywhere database connections > Temporary connections
  Name connection property	Returns the name of the current connection. For more information, see SQL Anywhere Server - Database Administration > Configuring your database > Connection, database, and database server properties > Connection properties
  ParentConnection connection property	Returns the connection ID of the connection that spawned the temporary connection. For more information, see SQL Anywhere Server - Database Administration > Configuring your database > Connection, database, and database server properties > Connection properties
  sa_conn_info System procedure	Reports connection property information. For more information, see Reference: Building Blocks, Tables, and Procedures > Catalog Stored Procedures > sa_conn_info System procedure
  sa_conn_list System procedure	Returns a result set containing connection IDs. For more information, see Reference: Building Blocks, Tables, and Procedures > Catalog Stored Procedures > sa_conn_list System procedure

  Note: These references point to SQL Anywhere documentation.

• Escape connection parameter support for ODBC data sources – By default the ODBC driver uses the tilde (~) as an escape character, but some applications assume that the escape character is the backslash (\). You can use the Escape connection parameter to specify the escape character for your application. You can also use the Escape connection parameter in connection dialogs.

  For more information, see SQL Anywhere Server - Database Administration > Administering your database > Database administration utilities > Data Source utility (dbdsn) > ODBC connection parameters

  Note: This reference points to SQL Anywhere documentation.

• TCP/IP connections – If you are connecting over TCP/IP, the database server name (specified by the ServerName (SERVER) connection parameter) is no longer mandatory if a host name is provided with the HOST connection parameter.

  For more information, see SQL Anywhere Server - Database Administration > Starting and connecting to your database > Connection parameters > Host connection parameter

  Note: This reference points to SQL Anywhere documentation.

• ServerPort (PORT) protocol option – In previous releases, the PORT protocol option indicated one or more port numbers on which the database server may be listening, but was considered a hint to the client library. When the client library sent out a broadcast, it would use the port numbers specified by the PORT protocol option, as well as the default port number, 2638. In this release, if the PORT option is specified, only the specified ports are used to find the database server.

  For more information, see SQL Anywhere Server - Database Administration > Starting and connecting to your database > Network protocol options > ServerPort (PORT) protocol option

  Note: This reference points to SQL Anywhere documentation.