BDE program errors "capability not supported", how to deal with?

The 2012-05-02 14:57:36 | classification: Delphi | tags: Delphi bde errors report | | size subscription
Written by Delphi 7 BDE program, not regularly appear in different computer capability not supported mistake, after Google, found Borland had discovered the bug, but it cannot solve the domestic many encounter people, specially reproduced:

Handling the "Capability not supported" error


By: Borland Staff

Abstract: An application written using the BDE, Delphi, or c + + Builder may return An error "capabilities are not supported.
"

Abstract: An application written using the BDE, Delphi, or c + + Builder may return An error "capabilities are not supported.
"
Problem:
An application written using the BDE, Delphi, or c + + Builder may return An error "capabilities are not supported.
"
Solution:
This error is returned by the BDE when the BDE parses an SQL
The string to be sent to a server and the syntax of the string is not
Supported by the BDE.

See below for more information on how the BDE sends pass
Through the SQL strings to DBMS servers and ODBC data sources.

The BDE, and Delphi and c + + Builder applications that use The
Data - aware components send SQL strings to DBMS servers
And the ODBC data sources depending on the setting of the
SQLQRYMODE parameters.

The Settings of The SQLQRYMODE parameter are listed in
In the BDE Administrator Help (formerly known as the BDE
The Configuration file Help), and are paraphrased below:

- The SQL string is sent to The server or The ODBC data source
First. If an error is returned, the string is then parsed
And ran by the BDE.
SERVER - The SQL string is sent to The SERVER or The ODBC data source, The if
An error is returned then the error is placed on the BDE
The error stack and the appropriate BDE error is returned.
LOCAL - The SQL string is parsed and ran by The BDE.

When the BDE parses and runs the SQL string due to the
SQLQRYMODE being set to blank or LOCAL, if the SQL
The string to be parsed is not supported by the BDE the
The error "Capability not supported" is returned.

The SQLQRYMODE parameter is found in both BDE alias
Definitions and BDE in driver definitions. The BDE will look for
This parameter first in the alias definition, if it is not found or the
Entry not a recognized the value or is corrupted then the BDE will
Look at this parameter in the driver definition. The Alias definitions
Can be created by using TDatabase component, by using the
DbiOpenDatabase () and DbiAddAlias (BDE) API calls, and by using the
The BDE Administrator (formerly the BDE Configuration) utility.



In fact, in addition to Borland this reason, many because: MSSQL types in the BDE Enabled BCD option not to TRUE, when the above can't solve your problems, might as well put the BDE MSSQL types of Enabled BCD try option to TRUE,