Improved UI for Database Profiles
\The Sandbox \PB History & Future \New In PB6 \Database Connectivity \UI for DB Profiles
UI for DB Profiles
INFORMIX 7.x DB Interface
Oracle 7.3 DB Interface
Oracle 8.0 DB Interface
INTERSOLV DB2 ODBC Driver
Sybase Open Client 11.1
Sybase 10 & 11 Dist App Interface
Release DBParm
Sybase OC 11.1 Security
Sybase OC 11.1 Directory
Accessing MS SQL Server 6.5
ODBC 3.0
Sybase DirectConnect
CommitOn- Disconnect
DateTimeAllowed DBParm
DBGatewayUDT DBParm
FormatArgsAsExp DBParm
HostReqOwner DBParm
LowerCaseIdent DBParm
ModifySyntax DBParm
PWDialog DBParm
TableCriteria DBParm
ThreadSafe DBParm
TrimSpaces DBParm
TRS DBParm
AutoCommit in Net-Gateway
PBCatalogOwner in Oracle
Increased DBParm Strings
PRINT Stmts in Stored Procs
Nondefault DB Trace Log File
Automatically Connect to DB

Description

PowerBuilder and InfoMaker 6.0 provide an improved user interface for creating and managing database profiles. A database profile is a named set of parameters stored in your PowerBuilder or InfoMaker initialization file that defines a connection to a particular database in the development environment.

The database profiles user interface has been completely redesigned in 6.0 for better ease of use. The components of the new user interface are:

  • Database Profiles dialog box

    • The main Database Profiles dialog box has been redesigned using a tree control format so you can easily see each installed Powersoft database interface and its database profiles. You can create, edit, and delete database profiles from this dialog box. In addition, when the ODBC interface or one of its profiles is selected, you can access the Configure ODBC dialog box to create, edit, or delete an ODBC data source definition.

  • Database Profile Setup dialog box for each interface

    • Each Powersoft database interface now has its own Database Profile Setup dialog box where you can set interface-specific connection options and DBParm parameters. For example, if you select the SYC interface and click New in the Database Profiles dialog box, the Database Profile Setup - Sybase System 10/System 11 dialog box displays, containing settings only for those connection options that apply to the SYC interface.

    The Database Profile Setup dialog box groups similar DBParm parameters on the same tabbed page, and lets you easily set values for DBParms using checkboxes, dropdown listboxes, and textboxes. As you complete the Database Profile Setup dialog box in PowerBuilder, the correct PowerScript connection syntax for each selected option is generated on the Preview tab. You can then copy the syntax you want from the Preview tab into your PowerBuilder script.

    The Preview tab is not available in the Database Profile Setup dialog box in InfoMaker.

Purpose

The improved user interface for creating and managing database profiles in PowerBuilder and InfoMaker 6.0 makes it easier for you to:

  • See a list of your database profiles organized by Powersoft database interface
  • Access the Configure ODBC dialog box to create and manage ODBC data source definitions
  • Supply values for the connection options required by your Powersoft database interface
  • Set DBParm parameters in the development environment without having to manually edit a complex and lengthy DBParm string
  • Generate correct PowerScript connection syntax in the PowerBuilder development environment for use in your PowerBuilder application script

Usage

The new user interface for database profiles changes the way you define, establish, manage, and troubleshoot database connections in PowerBuilder and InfoMaker.
PBL Peeper PB Help PB History & Future About Us Feedback Site Map

Google
 
Web www.techno-kitten.com
www.sybase.com