BDE Direct-attached access to Oracle in Delphi

Using Delphi to develop the database management information system based on Oracle platform, the Oracle background is generally considered in two ways, one is to use the driver provided by Oracle to connect with ODBC; One is to bypass ODBC and use the BDE direct connection method.

After the Oracle client configures the connection string, an Oracle alias is created in Bde, and the alias's server_name is set to the Oracle connection string, which can then be accessed by the alias. This article is mainly about the latter type of connection.

I use DELPHI4C/S (install the corresponding patch) in the development based on turbolinux+ ORACLE8.1.6 Housing subsidy management system process, is the use of BDE direct connection, BDE upgraded to 5.1.1, the problems encountered are as follows: As long as the date field in the datasheet has a null value, then all queries related to the Date field will appear as follows error? (See Figure 1)

The corresponding SQL statement has no problem under Sqlplus, which can only explain the problem of BDE itself. I downloaded the BDE5.1.1 on Borland's home page for the ORACLE8 version of the patch Sqlora8.dll, the version is 5.1.1.2, but the problem remains?! I asked the Chinese Borland Company, no results. Helpless, I copied the program to a colleague of the machine to try, incredibly no mistake!! Checked the SQLORA8.DLL version of the colleague's machine and found that the version was 5.0.1.22. I'll replace the copy of this file to solve the problem. Later, I test the other SQLORA8.DLL version, there are BDE errors. This also shows a problem: The high version of the software is not necessarily good, it can solve the problem. Those who wish to meet the same problem, solve the problem earlier, and take less detours.