Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I require to query an informix database using parameters and Excel. When the query is executed in Microsoft Query the dataset is fetched and returned succesfully, when I attempt to return to Excel the following error occurs:

[Informix][Informix ODBC Driver]General Error

The query is as follows:

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 =?))
share|improve this question
Can you add some details about how you are doing this in Excel? – Max Vernon Jun 3 '13 at 15:30
Ive connected to the data source through excel with the above query in MS Query. Ive then placed the two parameters in excel, cell A1 and B1. The query works in Microsoft Query, but displays the error when returned to Excel. – PDB Jun 3 '13 at 15:38
Any thoughts? @MaxVernon – PDB Jun 5 '13 at 14:15
How are you providing the parameters in Excel? – Max Vernon Jun 5 '13 at 20:39
Im wanting to set the query parameters as cells (eg A1 and B1) and then refreshthe query using them – PDB Jun 6 '13 at 9:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.