Advantage Database Server

Usage and Settings

Advantage with R&R ReportWorks

Usage and Settings

Advantage with R&R ReportWorks

Previous topic Next topic  

Usage and Settings

Advantage with R&R ReportWorks

Previous topic Next topic  

An additional driver is not required to use Advantage with R&R ReportWorks. The standard Advantage Client Engine (ace32/64.dll) and the Advantage Communications Layer (axcws32/64.dll) are the only client DLLs necessary.

 

To enable Advantage access from either the R&R XBase designer or the runtime, you must set the rr_use_ads environment variable (see table below).

 

Environment Variables

As there is no Advantage-specific connection type inside R&R, Advantage options and functionality is controlled via environment variables.

 

Variable Name

Description

rr_use_ads

This setting is required, otherwise R&R will not attempt to use Advantage.

rr_ads_show_errors

This setting can be used if debugging problems and you want to see the Advantage error codes and messages as they occur (instead of getting a                     generic file error from R&R).

rr_ads_index_map

This setting can be used if you have index files that are not structural. In this case the Advantage driver needs to be told what tables the indexes                       belong to, for example:

  rr_ads_index_map=index1.cdx=sometable.dbf;index2.cdx=sometable.dbf

rr_ads_table_passwords

This setting can be used to pass encryption passwords for encrypted free tables. A semi-colon delimited list of tablename/password pairs can be                     specified, or a single password for use with all tables can be specified. For example:

  rr_ads_table_passwords=table1.adt=mypassword1;table2=mypassword2

 

                          or

 

  rr_ads_table_passwords=password_for_all

rr_ads_locking

This setting can be used to specify the Advantage locking mode. The default locking mode is "compatible". To specify proprietary locking use:

  rr_ads_locking=proprietary

rr_ads_chartype

This setting can be used to specify the Advantage character type. The default char type is ANSI. To set it to OEM use:

  rr_ads_chartype=oem