Properties – PB Docs 125 – PowerBuilder Library

Properties database parameter

Description

Sets properties specific to the particular JDBC driver you
are using to connect to the database.

Controls

JDB JDBC

Syntax

Properties='<span>property_value</span>'

1	Properties='<span>property_value</span>'

Default

None

Usage

The Driver-Specific Properties box allows you to set properties
specific to a particular driver.

For information about the properties supported
by your JDBC driver, see the vendor’s documentation.

Define User ID and Password

If properties are defined, you must also
define the user ID and password in the properties box.

Examples

To set a property for the Sybase jConnect driver:

Database profile

Type the following in the Driver-Specify Properties box on
the Connection page in the Database Profile Setup dialog box:

PowerBuilder

SQLINITSTRING=set TextSize 32000; user=sa;password=manager

1

SQLINITSTRING=set TextSize 32000; user=sa;password=manager
Application

Type the following in code:

PowerBuilder

SQLCA.DbParameter="Properties='SQLINITSTRING=set TextSize 32000;user=sa;password=manager'"

1

SQLCA.DbParameter="Properties='SQLINITSTRING=set TextSize 32000;user=sa;password=manager'"

See Also

Driver
URL

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 12.5

Connection Reference Database parameters PB Docs 125 Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older

August 10, 2023

Was this article helpful?

Subscribe

0 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

0

Would love your thoughts, please comment.x

()