MS Query "Function Sequence Error"

I am running into an issue creating a parameter query in MS Query going against a DB2 database. When I execute the query I get a "Function Sequence Error" message and the query does not run. Our DB2 is version 8.1. I am using Office XP. Regular queries run just fine. I used to be able to run parameter queries some time ago.

I tried Googling this but did not come up with any definative answers.

Hi Jim

Where and what are the parameters? (Worksheet, hard coded). MSQuery is notoriously flaky on high end parameters, but if it is just >[Date] or somthing then it should be fine.

What has chnaged since you were last able to do it? Excel version, DB2 version. Using ODBC is a low-level data transfer technology and is sometimes good to drop back to, but for higher end stuf you may need to look to OLEDB or ADO.

That's not given you many answers but perhaps we can try and discount a few things as I never seen this error.

It is very simple parameters and it does not matter what I choose. It appears to be a DB2 issue. From what I have seen on Google a number of people have had the problem but I have not found a satisfactory resolution other than to trace the Query with a tracing tool. I have not gotten to that point yet. Just hopoing someone else might have run into this one and could give me some pointers.

As for using ADO or OLEDB I can do that without too much trouble. For simple queries however it is awfully nice to just use a simple paramterized query.