Page 1 of 1

VS2005 SqlDataSource

Posted: Sun 14 May 2006 02:48
by TillmanZ
Hi,

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?


Cheers

Posted: Mon 15 May 2006 07:33
by Alexey
You should remove all square brackets manually.

Posted: Mon 15 May 2006 21:02
by TillmanZ
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?

Best regards,

Tillman Zschucke

Posted: Tue 16 May 2006 13:44
by Alexey
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
by Guest
When can this next release be expected?

Posted: Wed 17 May 2006 06:26
by Alexey
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
by TillmanZ
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?

Best regards,

Tillman

Posted: Thu 18 May 2006 06:39
by Alexey
It would hardly be a solution. It would disfigure MySQLDirect .NET infrastructure. We are looking for another way to resolve this.