Delimiters in SQL Reporting Services utilizing ODBC Connector 3.51

Delimiters in SQL Reporting Services utilizing ODBC Connector 3.51

am 29.07.2009 19:16:50 von Eric Liu

------_=_NextPart_001_01CA1070.5C5AB6E0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I was wondering if anyone can help me out with this problem that I've
been encountering.

=20

I'm using Report Builder 2.0 (a free downloadable SQL Server 2008 report
builder) and I've been successful in getting the program to connect to a
MySQL 4.0.x database through the use of the ODBC Connector 3.51. =20

=20

I can do standard queries with no problem. The problem now is that I'm
trying to do a simple ranking function:

=20

SET @R=3D0;

SELECT @R:=3D@R+1 AS Rank, Singer, SongName FROM music_play_info=20

ORDER BY COUNT DESC;

=20

Unfortunately, no matter how I try to format the semicolon (with it,
without it, etc), it gives me an error when it tries to parse it:

=20

ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-4.0.26-nt-log]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 ';

SELECT @R:=3D@R+1 AS Rank, Singer, SongName

=20

Any ideas how I can get this compound statement to work through the ODBC
connector? Thanks,

=20

-Eric Liu

=20


------_=_NextPart_001_01CA1070.5C5AB6E0--