ADO.NET Provider for Microsoft Excel

Build 23.0.8839

Configuring the Cache Connection

Configuring the Caching Database

This section describes the properties for caching data to the persistent store of your choice.

CacheLocation

The CacheLocation property species the path to a file-system-based database. When caching is enabled, a file-system-based database is used by default. If CacheLocation is not specified, this database is stored at the path in Location. If neither of these connection properties are specified, the provider uses a platform-dependent default location.

CacheConnection

The CacheConnection property specifies a database driver and the connection string to the caching database.

CacheProvider

The CacheProvider property specifies a database driver and the connection string to the caching database.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839