Underlying ADO providers known issues and quirks

Access Client .net provider

• .Net Framework only
• Cannot retrieve store procedure datatable schema without invoking the procedure (SchemaOnly option ignored)

DB2 driver via DB2Connect license

• License file needs to be copied to {executable path}\clidriver\license folder
• A lot of Merge calls break with an unspecified system error. Older versions of ODBC driver had that issue that was fixed. Assuming 11.5 (2.x upwards for core) fixes this issue. Need a valid 11.5 license to verify
• ProviderSpecific bulk copy method seems to be very slow on 11.1

OleDb

• x86 calls with parameters break with underlying provider error
• Decfloats are truncated to smaller precision and scale
• Chars are trimmed by the provider
• Inline sql comments break the provider

ODBC

• Xml columns break on schema calls. A work around has been applied to make SQL calls work, but most schema operations fail. Avoid using this provider if your schema includes XML columns
• Truncate statemens succeed but throw an OverFlowException when reading the result code. Switched to DELETE statement (same as in v7.1) for ODBC.