Bug #65888 Hard to describe error. Case closed
Submitted: 12 Jul 2012 22:33 Modified: 17 Jul 2012 23:15
Reporter: Steve W Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.5.4 OS:Windows (Ver 7, 64 bit)
Assigned to: CPU Architecture:Any

[12 Jul 2012 22:33] Steve W
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.