I continue to get customer requests for options to migrate legacy RAD Studio, Delphi or C++ Builder applications using the Borland Database Engine (BDE) with Paradox and/or dBase files.
With the current versions of RAD Studio, you can use the FireDAC ODBC bridge driver to get to Paradox and dBase tables. This is important if you want to keep your legacy Paradox or dBase tables when you are migrating to newer versions of RAD Studio, Del...
In my recent CodeRage X talk I presented many examples of ODBC connectivity. However, there was a some more I wanted to say, but did not have time to do so. So, below is that content.
ODBC administrator has a 64 bit and 32 bit version on 64 bit versions of Windows. If you are using ODBC administrator from Control Panel, you are using the 64 bit version. To run the 32 bit version, you need to run c:\windows\syswow64\odbcad32.exe. The settings you make in the 64 bit or 32 bit version of ODBC ad...
The error in the title comes from InterBase. Actually, the full error is:
[DataDirect][ODBC InterBase driver][InterBase]Dynamic SQL Error, SQL error code = -804, SQLDA missing or incorrect version, or incorrect number/type of variables.
I've seen this error before when the wrong InterBase client (gds32.dll) version was loaded by the application, or when the wrong number of variables is passed to a stored procedure. But yesterday I found a new way to get the error. It took me quite a while ...