Incorrect number of parameters, expected 2.
- From: "Dave Williss" <dwillissNS@xxxxxxxxxxxxxxx>
- Date: Wed, 28 Sep 2005 14:56:37 -0500
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
.
- Follow-Ups:
- Re: Incorrect number of parameters, expected 2.
- From: Dmitriy Ivanov
- Re: Incorrect number of parameters, expected 2.
- From: Matt Neerincx [MSFT]
- Re: Incorrect number of parameters, expected 2.
- Prev by Date: Intermittent System.FormatException
- Next by Date: SQL
- Previous by thread: Intermittent System.FormatException
- Next by thread: Re: Incorrect number of parameters, expected 2.
- Index(es):