mysql查询语句出错? 400 报错

mysql查询语句出错? 400 报错

ASP中查询语句

背景:链接mysql数据库 数据库成功链接

问题:在ASP中书写SQL语句如下

sql="select a.ID,',' + a.PARENTPATH + ',' + CONVERT(varchar,a.ID) + ',' as PARENTPATH,isnull(b.ArticleCount,0) as ArticleCount from xy_class a left join (select count(*) as ArticleCount,classid from xy_article group by classid) b on a.ID = b.classid"

提示出错如下:

[MySQL][ODBC 5.1 Driver][mysqld-5.1.51-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar,a.ID) + ',' as PARENTPATH,isnull(b.ArticleCount,0) as ArticleCount from ' at line 1

提示语句有问题但是本人小白不太明白哪里有问题

(注:本语句链接MYSQL并非是SQLSERVER

 另:本语句链接SQLSERVER可成功执行)

问:链接MYSQL.SQL如何书写?

附:本人在网页制作过程中有遇到如下提示

                               Microsoft OLE DB Provider for ODBC Drivers错误'80040e21'

                                ODBC 驱动程序不支持所需的属性。

 问:出现这个问题该如何解决?

希望各位不吝赐教...