Connecting to Your Database
Working with Native Database Interfaces

Table of Contents

Using Native Database Interfaces

About native database interfaces

Components of a database interface connection

Using a native database interface

Using Adaptive Server Enterprise

Supported versions for Adaptive Server

Supported Adaptive Server datatypes

Basic software components for Adaptive Server

Preparing to use the Adaptive Server database

Defining the Adaptive Server database interface

Using Open Client security services

Using Open Client directory services

Using PRINT statements in Adaptive Server stored procedures

Creating a DataWindow object based on a cross-database join

Installing stored procedures in Adaptive Server databases

Using Informix

Supported versions for Informix

Supported Informix datatypes

Features supported by the I10 interface

Basic software components for Informix

Preparing to use the Informix database

Defining the Informix database interface

Accessing serial values in a PowerBuilder script

Using Microsoft SQL Server

Supported versions for SQL Server

Supported SQL Server datatypes

Basic software components for Microsoft SQL Server

Preparing to use the SQL Server database

Defining the SQL Server database interface

Migrating from the MSS or OLE DB database interfaces

SQL Server 2008 features

Notes on using the MSOLEDBSQL and SNC interfaces

Connection differences between MSOLEDBSQL 18.x and 19.x

Supporting TLS 1.3

Using Oracle

Supported versions for Oracle

Supported Oracle datatypes

Basic software components for Oracle

Preparing to use the Oracle database

Defining the Oracle database interface

Using Oracle stored procedures as a data source

Using Oracle user-defined types

Support for HA event notification

Support for identity column