Connection String Options
The connection string 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 string for this provider. Click the links for further details.
For more information on establishing a connection, see Basic Tab.
Property | Description |
DataSource | The path to the folder containing the .dbf files. |
IncludeFiles | Comma-separated list of file extensions to include into the set of table-content files. |
CodePage | The code page to use for decoding character fields. |
Property | Description |
LogModules | Core modules to be included in the log file. |
Property | Description |
Location | A path to the directory that contains the schema files defining tables, views, and stored procedures. |
Property | Description |
EmptyStringIsNull | Tells provider to expose empty strings as null values. |
ExcludeFileExtensions | Set to true if file extensions should be excluded from table names. |
MaxRows | Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time. |
Other | These hidden properties are used only in specific use cases. |
SetExactOn | Mimics beahviour of SET EXACT ON mode in Microsoft OLE DB provider. |
UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |