ODBC Connectivity Setup
Posted: Thu Nov 21, 2019 1:28 pm
When using the SAP/Advantage ODBC connector, the following configuration settings are recommended:
- DataDirectory=path_name
a valid path name to where the data files are located (e.g., x:\data). This path is used to automatically select all tables in the specified directory.
- DefaultType=FoxPro
- ServerTypes=1|2
Select 1 for Professional or Enterprise Edition, or 2 for Corporatee
- AdvantageLocking=OFF
- CharSet=OEM
- Language=OEM