PSQL Features Unavailable in the ActiveX Access Method

The following features are a part of PSQL but are not supported in the ActiveX access method.

ActiveX provides access to the MicroKernel Engine for a PSQL database. The access method does not provide access to the Relational Engine or provide SQL query processing functionality.

Chunk Operations, Huge Records

The ActiveX access method does not support PSQL chunk operation primitives. The maximum record size supported by the ActiveX access method is dictated by data dictionary limitations. The fixed record length limit is 4 KB, the combined fixed and variable length maximum is 32 KB.

Creating Files with Multiple ACS

The ActiveX access method does not expose interfaces to allow the creation of new tables with multiple Alternate Collating Sequences (ACS). However, the ActiveX access method will collate these indexes correctly in tables that use them.

Data Types

The following PSQL data types are not supported by the ActiveX access method:

•

LONGVARCHAR

•

LONGVARBINARY

URI Syntax

PSQL ActiveX uses the HostAddress and DatabaseName properties to build a URI for connection to remote machines. However, you cannot specify all the URI syntax parameters using code. If a database is secure, the prompt=yes parameter is used by the ActiveX controls to tell the MicroKernel Engine to prompt the user for credentials.