------_=_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.
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.
I can do standard queries with no problem. The problem now is that I'm
trying to do a simple ranking function:
SET [at] R=3D0;
SELECT [at] R:=3D [at] R+1 AS Rank, Singer, SongName FROM music_play_info
ORDER BY COUNT DESC;
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:
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 [at] R:=3D [at] R+1 AS Rank, Singer, SongName
Any ideas how I can get this compound statement to work through the ODBC
connector? Thanks,
-Eric Liu
------_=_NextPart_001_01CA1070.5C5AB6E0--
