"You have an error in your SQL syntax"

"You have an error in your SQL syntax"

Postby 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
Brogren
 

Postby Alexey » Fri 21 Jul 2006 08:41

You should remove all the square brackets in the query text.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL