Skip to Content.
Sympa Menu

freetds - Re: [freetds] MSSQL query not executing....

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] MSSQL query not executing....
  • Date: Wed, 4 Jan 2012 23:20:00 -0500

On Wed, 4 Jan 2012 17:41:27 -0700
Christopher Bielinski <cbielinski AT qualys.com> 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.




Archive powered by MHonArc 2.6.24.

Top of Page