Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 =?))

Hope you can help as I'm new to this.

Thanks in advance

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

 
discard

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

Browse other questions tagged or ask your own question.