VS2005 SqlDataSource
VS2005 SqlDataSource
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
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
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
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