"You have an error in your SQL syntax"

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply

"You have an error in your SQL syntax"

Post by Brogren » Fri 21 Jul 2006 08:07

Using VB2005 and MySQLDirect.Net allso a data base host by a webhotel in MySQL.

I have a connection in the Server explorer thats works fine, but when I drag a SqlDataSource to the page I can choose database, and I can se the tabeles but in the last step I can't test Query. Inseat I get this error messages.

"There was an error executing the quary. Please check the syntax of the command and if present, the types and values of the parameters and ensure they are correct.

You have error in your SQL syntax; check the manual that corresponds to your MySQL server version for right syntax to use '[Kunder]' at line 1"

Is somthing that's not installed on the database or is somting that I forgot to add in my reference or somthing else???? :?:

Thanks for help

Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 21 Jul 2006 08:41

You should remove all the square brackets in the query text.

Post Reply