Salesforce

ODBC Databases (Magic xpa 2.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

ODBC Databases (Magic xpa 2.x)

The following topics describe Magic xpa’s functionality when working with ODBC:

Default Database

ODBC supports the Database default.

Direct SQL

ODBC cannot be the Result Database in Direct SQL tasks.

Locking

No explicit table locks exist in ODBC. Therefore, Share-None and Share-Read have no effect. The underlying database engine itself executes the locking.

PostgreSQL

You access the PostgreSQL DBMS via ODBC. However, because of limitations in PostGreSQL, you cannot create a descending index.

Sort/Temporary Database

ODBC cannot be the database for Sort or Temporary tables.

Views

You must define a virtual unique index for a View. Insert, Update, and Delete operations are permitted on Views. Magic xpa will display an error message and will not convert or rename the View in the database.

The Magic xpa Single User Edition does not support the ODBC database.

Reference
Attachment 
Attachment