The following lists include the properties and methods that iASP does not support for Cloudscape ActiveX Data Objects. Functions with partial support contain explanatory text.

Command Object

• Prepared property
• Cancel - 2.0 method
• Execute(RecordsAffected,Parameters,Options) method (supported except for Options equal adAsyncExecute or adAsyncFetch)

Field Object

Unsupported properties:

• Type (supported only for a non-OLE DB type.)
• UnderlyingValue
  

Error Object

• HelpContext property

Property Object

• Type property (supported only for a non-OLE DB type.)

Recordset Object

Unsupported properties:

• CacheSize 
• Filter 
• LockType (supported except for Pessimistic lockign)
• MarshalOptions 

Unsupported methods:

• Clone
• NextRecordset
• Open (supported, except for multi-threads in ODBC)

Connection Object

Unsupported properties:

• DefaultDatabase
• IsolationLevel 
• Provider 

Unsupported methods:

• Execute(CommandText,RecordsAffected,Options ) (supported except for Options equal adAsyncExecute or adAsyncFetch)
• Open(ConnectionString,UserId,Password,Options) (supported except for Options equal adAsyncConnect) 
• OpenSchema(QueryType ) (See note.)
• OpenSchema(QueryType,Criteria ) (See note.)
• OpenSchema(QueryType,Criteria,SchemaId)
• Cancel -2.0

NOTE: The method, OpenSchema, is supported by iASP only if the QueryType's value is not equal to the one of Content:

"adSchemaAsserts, adSchemaCharacterSets, adSchemaCheckConstraints, adSchemaCollations, adSchemaConstraintColumnUsage, adSchemaConstraintTableUsage, adSchemaKeyColumnUsage, adSchemaProcedureParameters, adSchemaProviderSpecific, adSchemaSQLLanguages, adSchemaStatistics, adSchemaTableConstraints, adSchemaTranslations, adSchemaUsagePrivileges, adSchemaViewColumnUsage, adSchemaViewTableUsage, adSchemaViews"

The values of the Recordset.Fields that OpenSchema returns are different with IIS.

NOTE: If you require immediate support for an unsupported function, please email support@halcyonsoft.com.