login

The login method establishes a persistent connection to Adaptive Server Enterprise.

Syntax

login aseServerName userName password

Parameters

• aseServerName

  SOAP string indicating the name of the Adaptive Server Enterprise on which to execute the SQL statement or stored procedure.

  At each invocation of the execute method, Adaptive Server Enterprise Web Services uses the value of aseServerName in the following way:

  1. Adaptive Server Enterprise Web Services searches for an entry containing the value of aseServerName on an LDAP server pointed to by the libtcl.cfg file.

  2. If no entry is found on an LDAP server, Adaptive Server Enterprise Web Services looks for an entry in the interfaces file for Adaptive Server Enterprise.

     On Windows systems, this file is named sql.ini.

     Adaptive Server Enterprise Web Services locates the interfaces file using the com.sybase.ase.ws.interfaces entry in the ws.properties file.

  3. If no entry is found in the interfaces file for Adaptive Server Enterprise, execution fails for the execute method.

• username

  SOAP string indicating the user ID needed to log in to the Adaptive Server Enterprise.

• password

  SOAP string indicating the password needed to log in to the Adaptive Server Enterprise.

Usage

Before a SQL statement or stored procedure can be executed on Adaptive Server Enterprise, a connection must first be established. However, the login method is optional. If you invoke an execute method without first invoking the login method, Adaptive Server Enterprise Web Services automatically establishes a non-persistent connection to Adaptive Server Enterprise. The login method initiates a persistent connection to Adaptive Server Enterprise. The connection is terminated with the logout method. Persistent connections that are inactive for 60 seconds are terminated automatically.

Copyright © 2004. Sybase Inc. All rights reserved.

View this book as PDF