Re: Quoted Identifiers FreeTDS unixODBC

Just execute

set quoted_identifier off

after connecting

Frediano


2013/5/1 <[email protected]>

> Hello,
>
> Have unixODBC 2.3.1 configured with FreeTDS to provide MS SQLSERVER 2000
> support via ODBC.
>
> Connectivity and everything is fine except that we need a method to set
> quoted identifiers off.
>
> We also use Microsoft sqlncli via unixODBC to provide MS SQLSERVER
> 2005/2008/2012 support and this uses an odbc.ini setting of QuotedID = NO
> to do the job.
>
> This setting does not work when driver is FreeTDS (also freetds.conf seems
> bypassed).
>
> Is there a way to support QuotedID connection attribute using FreeTDS and
> unixODBC ?
>
> Many thanks for any help,
>
> GSi
>
> ************************************************************
> HSBC Bank plc may be solicited in the course of its placement efforts for
> a new issue, by investment clients of the firm for whom the Bank as a firm
> already provides other services. It may equally decide to allocate to its
> own proprietary book or with an associate of HSBC Group. This represents a
> potential conflict of interest. HSBC Bank plc has internal arrangements
> designed to ensure that the firm would give unbiased and full advice to
> the corporate finance client about the valuation and pricing of the
> offering as well as internal systems, controls and procedures to identify
> and manage conflicts of interest.
>
> HSBC Bank plc
> Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom
> Registered in England - Number 14259
> Authorised and regulated by the Financial Services Authority.
> ************************************************************
>
>
> -----------------------------------------
> SAVE PAPER - THINK BEFORE YOU PRINT!
>
> This transmission has been issued by a member of the HSBC Group
> "HSBC" for the information of the addressee only and should not be
> reproduced and/or distributed to any other person. Each page
> attached hereto must be read in conjunction with any disclaimer
> which forms part of it. Unless otherwise stated, this transmission
> is neither an offer nor the solicitation of an offer to sell or
> purchase any investment. Its contents are based on information
> obtained from sources believed to be reliable but HSBC makes no
> representation and accepts no responsibility or liability as to its
> completeness or accuracy.
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>