Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2013
    Posts
    2

    Question Unanswered: Excel Query: [Informix][Informix ODBC Driver]General Error.

    Hi,

    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:

    [Informix][Informix ODBC Driver]General Error.
    The driver is version 2.81 TC1 and the SQL query being executed is:

    Code:
    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 =?))
    I really hope someone can help or offer advice.

    Thank you

  2. #2
    Join Date
    Sep 2004
    Posts
    51
    Can you please provide the version of ODBC driver is using and the version of Informix database.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •