ODBC Driver for xBase

Connection String Options - xBase ODBC Driver



xBase Connection Options

The following table describes the options that you can include in the connection string for xBase:

Option Description

Database

Used to specify the folder in which the database files are located.

DBF Format

Used to specify the default database format that will be used when creating new tables and working with indexes. Available values: dBaseIII, dBaseIV, dBaseV, dBaseVII, FoxPro2, VisualFoxPro and HiPerSix. Default value is dBaseVII.

Code Page

Used to specify a code page when working with a database. Available values: Default, UnitedStatesOEM, GreekDOS, WesternEuropeanDOS, TurkishDOS, CentralEuropeanDOS, PortugueseDOS, IcelandicDOS, FrenchCanadianDOS, NordicDOS, CyrillicDOS, Thai, Japanese, ChineseSimplified, ChineseTraditional, Korean, CentralEuropeanANSI, CyrillicANSI, WesternEuropeanANSI, GreekANSI, TurkishANSI, HebrewANSI, ArabicANSI and BalticANSI. Default value is Default.

Connect Mode

Used to specify the way the connection operates the database tables. When Shared, multiple connections can open the same table at the same time. When Exclusive, an already opened table can not be opened by other connections. Default value is Shared. Note: Since the DBF database does not support transactions, an attempt to change the same table from different connections can cause corruption of the table data. Therefore, when using the Shared mode, the application itself must provide the integrity of the table data.

IndexOnReading

Specifies a mechanism of indexing when fetching tables data. Available values: Native and Local. When set to Native, the driver will use standard DBF index (if the one exists) when fetching data. When set to Local, the driver will use its internal data indexing mechanism. Internal indexing has much more performance than native indexes, especially when performing complex queries against many tables. But note, that in this case a native index if it is present for a table, will not be updated when the table data changed (for example, when a UPDATE statement executed). So, it is recommended to use Local indexing only for querying data.

String Types

Sets the string value types returned by the driver as Default, Ansi or Unicode.

  • Default - the driver defines the string types.
  • Ansi - all string types will be returned as SQL_CHAR, SQL_VARCHAR and SLQ_LONGVARCHAR.
  • Unicode - all string types will be returned as SQL_WCHAR, SQL_WVARCHAR and SLQ_WLONGVARCHAR.

The option value should be changed if any third-party tool supports only Ansi string types or Unicode ones.

xBase ODBC Connection String sample

DRIVER={Devart ODBC Driver for xBase};Database=C:\MyDatabase\;DBF Format=VisualFoxPro;Code Page=UnitedStatesOEM;Connect Mode=Exlusive

© 2015-2018 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback