SetFallBackDBMS Method

English Query

SetFallBackDBMS Method

Sets the alternate database type and version for which a query is generated if none can be generated for the primary database.

Applies To

Session Object

Syntax

Session.SetFallBackDBMS(Type, [Version])

Parts

Session

An object variable that represents an existing domain object.

Type

An integer that represents the database type.

The values for Type includes the following:

Value	Database type	Description
0	nlDBMSSQLServer	Microsoft® SQL Server™ 2000
1	nlDBMSMSOlap	SQL Server 2000 Analysis Services
2	nlDBMSOracle	Oracle

Version

A string in the form of nn, mm, xx, yy that represents the version of the database. Optional.

Remarks

FallbackDBMSType and FallBackDBMSVersion properties are used to generate a query if English Query cannot generate a query using the primary database. This occurs only if the primary database is nlDBMSMSOlap. The fallback database must be an SQL database such as nlDBMSSQLServer.

To set it so that there is no fallback database, use SetFallbackDBMS with no arguments. If there is no fallback database and English Query cannot generate a query using the primary database, English Query returns an error response.