Question:
Why am I getting blank data or the error "Could not find object" when trying to do a heterogeneous query in Delphi?
Answer:
The BDE does not support the new unicode data types introduced in MSSQL7 (more info). This will prevent you from doing the heterogeneous query if the columns you are linking are one of these data types. One workaround is to do the heterogeneous join using MS SQL 7 server and then access the data from Delphi using ADO. See the following for more: http://msdn.microsoft.com/msdnmag/issues/0800/cutting/cutting0800.asp
Last Modified: 28-AUG-01