Solved

SQLBindParameter not used for all parameters

Posted on 2003-11-24
4
3,422 Views
Last Modified: 2012-05-04
I'm trying to update a table in mySQL database but I'm getting this error message:
ERROR [07002] [MySQL][ODBC 3.51 Driver][mysqld-4.0.16-max-debug]SQLBindParameter not used for all parameters.
What could be wrong?Thanks
0
Comment
Question by:viktor999
4 Comments
 
LVL 17

Expert Comment

by:Squeebee
ID: 9813065
What does you code look like?
0
 
LVL 1

Accepted Solution

by:
jtremback earned 50 total points
ID: 10965649
I had the same problem...then I realized my parameter count was off. Check

MySQLDataAdapter.InsertCommand.Parameters.Count

and make sure the count equals the total number of values you are trying to insert.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now