Syntax 2For the Web DataWindow server component – PB Docs 126

Syntax 2For the Web DataWindow server component

Description

Specifies connection information for the Web DataWindow, such
as the database name.

Controls

DataWindow type	Method applies to
Web	Server component

Syntax

Argument	Description
dwcontrol	A reference to a DataWindow control, DataStore, or child DataWindow in which you want to set the values of the internal transaction object.
dbms	PowerBuilder vendor identifier.
dbparm	DBMS-specific parameters. For example, this connection string uses the Sybase JConnect driver and connects to SQL Anywhere running on the local machine (localhost): PowerBuilder "Driver='com.sybase.jdbc3.jdbc.SybDriver',URL ='jdbc:sybase:Tds:localhost:7373'" 1 "Driver='com.sybase.jdbc3.jdbc.SybDriver',URL ='jdbc:sybase:Tds:localhost:7373'"
lock	The isolation level. For information about values for different types of connections, see Connecting to Your Database.
logid	The name or ID to be used to log on to the database server.
logpass	The password to be used to log on to the server.
database	The name of the database to which you are connecting.
servername	The name of the server where the database resides.

Return Values

Returns 1 if it succeeds and –1 if an error occurs.

Usage

When the server component is installed in EAServer, you must use EAServer
Manager to set up a connection cache for the component.

You use SetTrans when you want the DataWindow
engine to manage database connections, transaction state primitives,
and related EAServer component
deactivation. This is incompatible with the UseContextObject database
parameter, which you set only to retain control of connection and transaction
functions yourself.

Because the default Web DataWindow component uses SetTrans to specify
database connection information, you must not set the UseContextObject
database parameter to Yes in your database
profile or in the EAServer properties
for the component.

Examples

See Also

Retrieve

---