Page 1 of 1
Posted: Sun 14 May 2006 02:48
it seems as if the auto-generated SQL statements will not work with the MySQLConnector. VS2005 generates square-brackets  around each field name. Obviously something mysql (running 4.0.x on Linux) doesn't like.
Is this a bug or can I fix it by using any magic?
Posted: Mon 15 May 2006 07:33
You should remove all square brackets manually.
Posted: Mon 15 May 2006 21:02
Thanks for your support - it does of course work to omit the square brackets but the sqldatasource then identifies the select query as "custom" and thus I will not be able to see the data structure (columns) at design time when working with grids.
Obviously it's not really a big thing to change in the corelab adapter to delete the brackets before sending the string to the mysql server.
When will that bug be fixed?
Posted: Tue 16 May 2006 13:44
This problem is connected with SqlDataSource component. We can't change it. We will try to workaround this problem. Look forward to the next releases.
Posted: Tue 16 May 2006 22:08
When can this next release be expected?
Posted: Wed 17 May 2006 06:26
We don't guarantee to fix this problem in the next release. I repeat: it's VS's problem.
Posted: Wed 17 May 2006 13:47
Thanks Alexey for explaining the situation.
I was hoping that the corelab connector could filter those square brackets before sending the sql query to the server.
Am I missing something in that thought?
Posted: Thu 18 May 2006 06:39
It would hardly be a solution. It would disfigure MySQLDirect .NET infrastructure. We are looking for another way to resolve this.