Description:
Using VB2010 with the MySQL .NET 6.5.4 connector
Getting this peculiar error, when calling the TableAdapter.Fill. What is peculiar is this is the same line of code used in the Form_Load event with no problem. No changes are made that should impact it.
Me.thisTableAdapter.Fill(Me.DataSet.thisTable)
Here's the error - note the quote mark.
You have an error in your SQL syntax; check the manual.....for the right syntax to use near " at line 1
The error occurs if I update the remote DB or not. The update is successful, if I choose to do it. This TableAdapter refills a dropdown ComboBox, and that is also successful.
The error is not caught by any Try/Catch exception handling. A simple dialog box pops up, I click OK , and the code continues on after the error.
How to repeat:
Create an app in VB2010.