Table of Contents

Concept differences

Connection differences

Transaction differences

One transaction vs. multiple transactions

Transaction timeout vs. no transaction timeout

Transaction management differences

Transaction issues

Transaction timeout in stored procedure

Select Lock

DBParm differences

Supporting multiple database types

Database type & driver

Database type

Database driver

ASE database

Caches

What is a cache?

Creating caches in the IDE

Download the database driver

Configure the database connection

Create the DB connection profile

Managing caches in PowerServer

Connection techniques

Connection options

Handling various connection scenarios

Static connection

Creating transaction-to-cache mappings in the IDE

Managing transaction-to-cache mappings in PowerServer

Dynamic connection

Using CacheName property of DBParm

Using CacheGroup property of DBParm

Using LogID and LogPass properties

Using Transaction object properties

Long connection

When to enable long connection

How to enable long connection

Managing database connections

Storing database connections in the file or database

Managing database connections via APIs

Walkthrough: Connecting to the database

Overview

Accessing the Database Configuration dialog

Connecting with the DB2 database

Installing DB2 driver

Creating a cache

Mapping the transaction object

Connecting with the Informix database

Installing Informix driver

Creating a cache

Mapping the transaction object

Connecting with the MySQL database

Installing MySQL driver

Creating a cache

Mapping the transaction object

Connecting with the Oracle database

Installing Oracle driver

Creating a cache

Connection types in Oracle

Mapping the transaction object

Connecting with the PostgreSQL database

Creating a cache

Mapping the transaction object

Connecting with the SQL Anywhere database

Starting the SQL Anywhere database

Configuring ODBC for SQL Anywhere

Creating a cache

Mapping the transaction object

Connecting to SQL Anywhere database in Linux

Connecting with the SQL Server database

Selecting a proper authentication mode when configuring SQL Server connection

Configuring the SQL Server database server

Creating a cache

Connecting to Azure SQL

Mapping the transaction object

Connecting with the Adaptive Server Enterprise database

Configuring ODBC for ASE

Creating a cache

Mapping the transaction object

Troubleshooting

Unable to connect to remote SQL Server database over Named Pipes even though local database can be connected

Using the PostgreSQL CA certificate for SSL connection, the verification fails

Communication error when connecting with the Informix database