ODBC Databases (Magic xpa 4.x)
The following topics describe Magic xpa’s functionality when working with ODBC:
Magic xpa Data Types
ODBC Data Types
Database Information – ODBC
Database Troubleshooting
ODBC Check Driver Utility
The following is additional information about working with the ODBC database:
|
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.
|
