Skip to Content.
Sympa Menu

freetds - [freetds] Quoted Identifiers FreeTDS unixODBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: graham.simpson AT hsbcib.com
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Quoted Identifiers FreeTDS unixODBC
  • Date: Wed, 1 May 2013 08:41:32 +0100

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.
>From gcdtf-freetds AT m.gmane.org Wed May 1 15:30:12 2013
Return-Path: <gcdtf-freetds AT m.gmane.org>
X-Original-To: freetds AT lists.ibiblio.org
Delivered-To: freetds AT lists.ibiblio.org
Received: by lists.ibiblio.org (Postfix, from userid 20217)
id 41FFDE8D1A; Wed, 1 May 2013 15:30:12 -0400 (EDT)
X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on
mailman1.ibiblio.org
X-Spam-Level:
X-Spam-Status: No, score=-1.0 required=5.0 tests=BAYES_00,
DKIM_ADSP_CUSTOM_MED,
NML_ADSP_CUSTOM_MED,RCVD_IN_DNSWL_NONE autolearn=no version=3.3.1
X-Greylist: delayed 901 seconds by postgrey-1.34 at mailman1.ibiblio.org;
Wed, 01 May 2013 15:30:07 EDT
Received: from plane.gmane.org (plane.gmane.org [80.91.229.3])
by lists.ibiblio.org (Postfix) with ESMTP id 685D2E8CC2
for <freetds AT lists.ibiblio.org>; Wed, 1 May 2013 15:30:06 -0400 (EDT)
Received: from list by plane.gmane.org with local (Exim 4.69)
(envelope-from <gcdtf-freetds AT m.gmane.org>) id 1UXcUZ-00036d-82
for freetds AT lists.ibiblio.org; Wed, 01 May 2013 21:15:03 +0200
Received: from locust-13-8-125.ext.uswestgw.xerox.com ([13.8.125.10])
by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
id 1AlnuQ-0007hv-00
for <freetds AT lists.ibiblio.org>; Wed, 01 May 2013 21:15:03 +0200
Received: from gopi519 by locust-13-8-125.ext.uswestgw.xerox.com with local
(Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
for <freetds AT lists.ibiblio.org>; Wed, 01 May 2013 21:15:03 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: freetds AT lists.ibiblio.org
From: Kriskon <gopi519 AT gmail.com>
Date: Wed, 1 May 2013 19:10:30 +0000 (UTC)
Lines: 51
Message-ID: <loom.20130501T210741-642 AT post.gmane.org>
References:
<CA+zZJt8jKZu8_78BcQF7QoW_DVp5=ZDRDmr42F9Ui-8wSVZV6A AT mail.gmail.com>
<CAHt6W4eBGy+=e1iSDJNRtk_Ak=4SkU7xcqmyAVKOjQT042sP9w AT mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet AT ger.gmane.org
X-Gmane-NNTP-Posting-Host: sea.gmane.org
User-Agent: Loom/3.14 (http://gmane.org/)
X-Loom-IP: 13.8.125.10 (Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31
(KHTML,
like Gecko) Chrome/26.0.1410.64 Safari/537.31)
Subject: Re: [freetds] FreeTDS registration with unixODBC
X-BeenThere: freetds AT lists.ibiblio.org
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
List-Id: FreeTDS Development Group <freetds.lists.ibiblio.org>
List-Unsubscribe: <http://lists.ibiblio.org/mailman/listinfo/freetds>,
<mailto:freetds-request AT lists.ibiblio.org?subject=unsubscribe>
List-Archive: <https://lists.ibiblio.org/sympa/arc/freetds>
List-Post: <mailto:freetds AT lists.ibiblio.org>
List-Help: <mailto:sympa AT lists.ibiblio.org?subject=HELP>
List-Subscribe: <http://lists.ibiblio.org/mailman/listinfo/freetds>,
<mailto:freetds-request AT lists.ibiblio.org?subject=subscribe>
X-List-Received-Date: Wed, 01 May 2013 19:30:12 -0000

Frediano Ziglio <freddy77 <at> gmail.com> writes:

>
> There should be a section name in the file, something like
>
> [FreeTDS]
> Description = v0.91 with protocol v4.2
> Driver = /usr/local/lib/libtdsodbc.so
>
> Frediano
>
> 2013/4/30 Gopi <gopi519 <at> gmail.com>
>
> > Hi All,
> >
> > I installed unixODBC and FreeTDS on a solaris server. I m trying to
> > register the FreeTDS driver with unixODBC.
> >
> > cat tds.driver.template
> > Description = v0.91 with protocol v4.2
> > Driver = /usr/local/lib/libtdsodbc.so
> >
> > odbcinst -i -d -f tds.driver.template
> > odbcinst: iniOpen failed on tds.driver.template.
> >
> >
> > This is the error I come across on trying to register. Can anyone advice
> > how to move ahead on this?
> >
> > Thanks,
> > Kriskon
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS <at> lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>


Hi Ziglio,

Thanks for your valuable suggestion. As I made that change, after running
the odbcinst it came up with error ..

odbcinst: SQLInstallDriverEx failed with Unable to find component name.

Any idea on this.
Greatly appreciate your help.

Thanks,
Kriskon





Archive powered by MHonArc 2.6.24.

Top of Page