The connection properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection settings for this provider. Click the links for further details.For more information on establishing a connection, see Establishing a Connection.
|The path to the folder containing the .dbf files.
|Comma-separated list of file extensions to include into the set of table-content files.
|The code page to use for decoding character fields.
|A filepath which designates the name and location of the log file.
|The verbosity level that determines the amount of detail included in the log file.
|Core modules to be included in the log file.
|A string specifying the maximum size in bytes for a log file (for example, 10 MB).
|A string specifying the maximum file count of log files.
|A path to the directory that contains the schema files defining tables, views, and stored procedures.
|This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
|This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
|Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.
|Automatically caches the results of SELECT queries into a cache database specified by either CacheLocation or both of CacheConnection and CacheProvider .
|The name of the provider to be used to cache data.
|The connection string for the cache database. This property is always used in conjunction with CacheProvider . Setting both properties will override the value set for CacheLocation for caching data.
|Specifies the path to the cache when caching to a file.
|The tolerance for stale data in the cache specified in seconds when using AutoCache .
|Use offline mode to get the data from the cache instead of the live source.
|This property determines whether or not to cache the table metadata to a file store.
|Tells provider to expose empty strings as null values.
|Set to true if file extensions should be excluded from table names.
|Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
|These hidden properties are used only in specific use cases.
|Mimics beahviour of SET EXACT ON mode in Microsoft OLE DB provider.
|A filepath pointing to the JSON configuration file containing your custom views.