var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Excel Query: [Informix][Informix ODBC Driver]General Error.
Im using Microsoft Excel to query an informix database using to parameters that are in Cell A1 and B1.
When the SQL statement is executed in Microsoft Query it works and returns the required data, but the following error occurs when returned to Excel:
The driver is version 2.81 TC1 and the SQL query being executed is:
[Informix][Informix ODBC Driver]General Error.
I really hope someone can help or offer advice.
SELECT DISTINCT t1.r1, t1.r2, t2.r3, t2.r4
FROM informix.t1, informix.t2
WHERE t1.r1 = t2.r5 AND ((t2.r3=?) AND (t2.r4 =?))
Can you please provide the version of ODBC driver is using and the version of Informix database.
Tags for this Thread