[Microsoft] [ODBC Text Driver] Too few parameters. Expected:1


Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

TechKnowledge Content


Question:

Using the Advanced ODBC query with the SQL statement typed in, when exiting the query a"[Microsoft] [ODBC Text Driver] Too few parameters. Expected:1" error is returned. What is causing this?


Answer:

The statement that was being used was: SELECT *.* from vendors.txt WHERE [Vendor ID] = AAAAA


The error was caused because the value for the WHERE clause was not enclosed in quotes. OnceAAAAA was changed to 'AAAAA' the query was saved without error. Other incorrect formatting like extra spaces in the SQL statement can also cause this error.





This article was TechKnowledge Document ID:9704