[freetds] MSSQL syntax flavors

Andrew Pimlott andrew at pimlott.net
Thu Jul 3 19:13:06 EDT 2003


On Thu, Jul 03, 2003 at 11:25:40AM -0400, Lowden, James K wrote:
> The differences you're describing are in the application, not the protocol.
> If you are using TDS 7.0 with sqsh, then the server really can't distinguish
> between sqsh and any Microsoft ODBC tool.  

That's probably part of it (can't test right now), but I'm having
trouble believing this is the whole story.  For example, I got a
message like the following with sqsh, which clearly came from the
database:

    Msg 207, Level 16, State 3
    Server 'DATABASE', Procedure 'proc', Line 19
    Invalid column name 'col'.

The same code went through the MS Query Analyzer with no problems.
Maybe the MS tool is swallowing warnings/errors?

Thanks for the suggestion about sqsh.  It didn't occur to me that it
would do so much interpretation in batch mode.

Andrew



More information about the FreeTDS mailing list