Incorrect number of parameters, expected 2.

Tech-Archive recommends: Fix windows errors by optimizing your registry



I've found all sorts of stuff on the web that explain this error, but none
of them apply to the case I have.

If I use ODBC to connect to the Northwind sample database, and execute the
statement

SELECT COUNT(*) from "Customers and Suppliers by City";

I get the error

Incorrect number of parameters, expected 2.

Everything I find on the web indicates that this is because it's a
"parameter query", but this one isn't.
"Employee Sales by Country" and "Sales by Year" are, and the explanation
works just fine for them, but the Customers and Suppliers by City query has
no parameters. So what does it want?

--
-- Dave Williss
------
Meddle not in the affairs of dragons,
for you are crunchy and taste good with catsup


.