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
Syntax
Session.SetFallBackDBMS(Type, [Version])
Parts
Session
An
Type
An
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
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.