Oracle 7.3 Database Interface
\The Sandbox \PB History & Future \New In PB6 \Database Connectivity \Oracle 7.3 DB Interface
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 provide a new Oracle 7.3 native database interface that accesses Oracle 7.3 database servers.

The Oracle 7.3 database interface goes through Oracle SQL*Net client software Version 2.3 (on Windows, Macintosh, Solaris, and AIX) or Version 2.3.3 (on HP-UX) to make the connection. Therefore, you must have the appropriate version of SQL*Net for your platform installed on the client machine to use the interface.

Supported platforms

PowerBuilder and InfoMaker provide the Oracle 7.3 interface on all supported platforms.

Purpose

Use the Oracle 7.3 database interface when you want to access an Oracle 7.3 database server in PowerBuilder or InfoMaker through Oracle SQL*Net client software Version 2.3 or higher.

If you are using an earlier version of SQL*Net to access a different version of the Oracle database server, you should instead use one of the other Oracle native database interfaces in PowerBuilder or InfoMaker to access your data.

Usage

The information in Connecting to Your Database about using the other Oracle 7.x native database interfaces also applies when you use the Oracle 7.3 database interface, with the following differences:

Required client software  To use the Oracle 7.3 database interface in PowerBuilder or InfoMaker, make sure the following software is installed on the client machine as appropriate for your operating system platform:

  • Oracle SQL*Net Version 2.3 or higher (on Windows, Macintosh, Solaris, and AIX)
    or
    Oracle SQL*Net Version 2.3.3 or higher (on HP-UX)
  • PowerBuilder or InfoMaker Version 5.0.03 or higher
  • Oracle 7.3 native database interface that comes with PowerBuilder or InfoMaker

DBMS identifier  When you specify the DBMS identifier in a PowerBuilder application script, you must use O73 to connect to the database through the Oracle 7.3 database interface. (You no longer need to specify the DBMS identifier in a database profile. When you create a new profile for any installed Powersoft database interface, PowerBuilder or InfoMaker generates the correct DBMS connection syntax automatically.)

  • To specify the O73 DBMS identifier in a PowerBuilder script:

    • Type the following in your PowerBuilder application script:

    SQLCA.DBMS="O73"

    When you select O73 Oracle v7.3 in the Database Profiles dialog box and click New to create a new profile, this syntax displays on the Preview tab in the Database Profile Setup - Oracle 7.3 dialog box. You can then copy the syntax from the Preview tab into your script.

DBParm parameters

The information in Connecting to Your Database about setting additional connection parameters for the other Oracle 7.x database interfaces also applies to the Oracle 7.3 interface, with one exception.

The Oracle 7.3 interface on Windows and Macintosh includes a new DBParm parameter named ThreadSafe. ThreadSafe specifies whether your connection should take advantage of the Oracle 7.3 thread-safe client libraries.
PBL Peeper PB Help PB History & Future About Us Feedback Site Map

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