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.6

and Functions Events Objects and Controls PB Docs 126 PowerBuilder .NET Powerbuilder Documentation Powerbuilder Documentation 12.6 Powerbuilder Documentation Older PowerBuilder Extension Reference PowerBuilder New Features 12.6 PowerDesigner Integration System Object Properties Using the ADO.NET Interface

August 14, 2023

Was this article helpful?

Subscribe

0 Comments

Inline Feedbacks

View all comments

0

Would love your thoughts, please comment.x

()