[freetds] MSSQL syntax flavors

Andrew Pimlott andrew at pimlott.net
Wed Jul 2 21:21:24 EDT 2003


This is a question along the lines of the observation I made a few
days ago, about how MS SQL Server interprets commands differently
depending on what protocol or flags you connect with.  I have
another example that I haven't been able to resolve.

I have a create trigger statement (that I didn't write) with a line

        declare @rc int;

When I run it with sqsh, I get

    Line 8: Incorrect syntax near 'int'.

(line 8 being that line).  If I erase the ';', it runs fine.  The
original code runs fine in a native MSSQL query tool.

The server is SQL Server 2000.  My freetds is 0.61-4 in Debian
testing.  I have "tds version = 7.0" in my freetds.conf, and no
other changes from what Debian distributes.  I tried all the other
values of "tds version" as well, to no avail.

I hope you don't mind this sort of question here.  I'm loathe to
pore through the MS documentation when I don't really even know what
I'm looking for.  Maybe someone here could give me a hint as to
where to look, if nobody recognizes the issue right away.

Andrew


More information about the FreeTDS mailing list