ADO Client
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 9.0
- Documentation
Note: The ADO and ADO.NET clients are currently available only in OpenAccess SDK 8.1. However, they are compatible with the OpenAccess SDK 9.0 server.
The following table lists the data types that the ADO Client supports for the OpenAccess SDK SQL engine or a third-party SQL engine:
Mapping OpenAccess SDK Data Types to ADO Data Types
| OpenAccess Data Type | OLE DB Data Type |
| BIGINT | DBTYPE_I8 |
| BINARY | DBTYPE_BYTES |
| BIT | DBTYPE_BOOL |
| CHAR | DBTYPE_STR |
| DATE | DBTYPE_DBDATE |
| DOUBLE | DBTYPE_R8 |
| FLOAT | DBTYPE_R8 |
| INTEGER | DBTYPE_I4 |
| LONGVARBINARY | DBTYPE_BYTES |
| LONGVARCHAR | DBTYPE_BYTES |
| NUMERIC | DBTYPE_NUMERIC |
| REAL | DBTYPE_R4 |
| SMALLINT | DBTYPE_I2 |
| TIME | DBTYPE_DBTIME |
| TIMESTAMP | DBTYPE_TIMESTAMP1DBTYPE_STR2 |
| TINYINT | DBTYPE_UI1 |
| VARBINARY | DBTYPE_BYTES |
| VARCHAR | DBTYPE_STR |
| WCHAR | DBTYPE_STR |
| WLONGVARCHAR | DBTYPE_STR |
1 Only present when DataSourceFetchTimestampAsString=False
2 Only present when DataSourceFetchTimestampAsString=True