Re: MSSQL query not executing....

On Wed, 4 Jan 2012 17:41:27 -0700
Christopher Bielinski <[email protected]> wrote:

> This query runs in the SSMS browser, but doesn?t when I
> pipe it through FreeTDS.  I was wondering if the query was properly
> written (to the specs of FreeTDS), or if I?m missing something.  

There is no "properly written query" as far as FreeTDS is concerned.
The SQL is sent verbatim[1] to the server and the results conveyed to
the client.  FreeTDS doesn't actually care if it's SQL or some other
query language.  

Two things that can cause different execution results in different
environments are (1) the account executing the query and (2) the
session properties.  Cf.
http://msdn.microsoft.com/en-us/library/ms177525.aspx.

HTH.  

--jkl

[1] Not quite true for ODBC.