Step by Step: Setting up Linux ODBC driver for SQL Server


After setting up Redhat Linux 6.3 in Hyper V image follow the instructions outlined on TechNet – http://technet.microsoft.com/en-us/library/hh568449.aspx to install the Driver Manager.

clip_image002 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1) Go to unixODBC (http://www.unixodbc.org/) page and select Download

2)

Download the unixODBC-2.3.0 version.

clip_image004

 

 

clip_image006

 

 

3) Extract the files

clip_image008

4) Start a Terminal session

Note: Ensure that gcc (C compiler) is installed and in PATH

Type the following commands, ensuring you are running as the root user and in the directory where the ODBC driver files where extracted.

CPPFLAGS="-DSIZEOF_LONG_INT=8

No messages will be seen after execution of this command

export CPPFLAGS

No messages will be seen after execution of this command

./configure –prefix=/usr –libdir=/usr/lib64 –sysconfdir=/etc –enable-gui=no –enable-drivers=no –enable-iconv –with-iconv-char-enc=UTF8 –with-iconv-ucode-enc=UTF16LE

There will be compilation activity taking place and you will see the following screen:

clip_image010

Type make

There will be lots of messages similar to those on the screen

clip_image012

Type make install (this requires that you are logged in as the root user)

clip_image014

Now we can install the SSQL Server ODBC Driver for Linux. For more information see – http://technet.microsoft.com/en-us/library/hh568454.aspx

1) Extract out the native client files. These can be downloaded from – http://www.microsoft.com/en-us/download/details.aspx?id=28160. Ensure you download the appropriate version for your Red Hat version.

clip_image016

2) Open up Terminal window – change directory to the location where files where extracted

clip_image018

Type ./install.sh – it will just output information as per above screenshot. Next type ./install.sh verify. It will indicate if the computer has all the required components to install the Driver for Linux.

If it comes back with OK for all then we can proceed to install.

Type ./install.sh install

License agreement displays

clip_image020

Keep on pressing space bar to move the text along

Type YES if you agree to the license and to complete the installation

clip_image022

Run the following command to verify that the SQL Server ODBC Driver for Linux was registered successfully: odbcinst -q -d -n "SQL Server Native Client 11.0"

clip_image024

Test out connectivity to SQL Server using sqlcmd or Sample C++ code which can be found at – http://blogs.msdn.com/b/sqlblog/archive/2012/01/26/use-existing-msdn-c-odbc-samples-for-microsoft-linux-odbc-driver.aspx.

I used sqlcmd as per below screenshot:

clip_image026

 

Now your Linux based applications can enjoy the use of SQL Server 2012, so don’t let the requirement of Linux applications stop you from using your favorite database system – SQL Server 2012.

Comments (4)

  1. WQ says:

    http://www.fashionclothing.mex.com/ Sure,
    http://www.louisvuitton.so/ the process
    http://www.burberryonlineshop.de/ of flinging
    http://www.nikefree-run.org.uk/ a spinnerbait
    http://www.harrods-london.co.uk/ may
    http://www.airmax-90.org/ catch
    http://www.pradashoes.com.co/ a http://www.lululemoncanada.ca/ rogue fish off
    http://www.nike-air-max.com.de/ of
    http://www.yoga-pants.ca/ nothing http://www.rayban.com.de/ here and
    http://www.longchampoutlet.com.co/ there,
    http://www.babyliss.us.org/ but
    http://www.nike-air-max.ca/ I’ve found that
    http://www.nike-roshe-run.de/ during the
    http://www.nike-air-max.com.au/ course
    http://www.the-north-face.ca/ of the http://www.longchamp.us.org/ average true
    http://www.ghdhairstraightener.com.co/ cover-seeking day, your
    http://www.newbalance.com.es/ only looking
    http://www.nike-rosherun.nl/ for a
    http://www.burberry-outlet.me.uk/ few extra bites
    http://www.abercrombie-hollister.nl/ from “between”
    http://www.rolex-watches-canada.ca/ bass.
    http://www.christianlouboutin.org.uk/ I’d
    http://www.swarovski-australia.com.au/ rather
    http://www.hollister-abercrombie.com.se/ be
    http://www.converse.com.de/ locked http://www.tiffany-und-co.de/ and
    http://www.truereligionjeans.net.co/ loaded for
    http://www.bcbgdresses.in.net/ the
    http://www.ralphlaurenoutletonline.in.net/ gentle
    http://www.the-northface.com.co/ pitch, then
    http://www.coachoutlet-online.com.co/ carelessly
    http://www.louis-vuittonoutletcanada.ca/ unleashing
    http://www.longchamp.com.de/ the http://www.mmoncler-outlet.com/ firing
    http://www.montblanc–pens.in.net/ squad.
    http://www.ralphlaurenoutletonline.us.org/ What
    http://www.guccioutlet.us.org/ I
    http://www.uggs.co.nl/ mean
    http://www.cheapoakleysunglasses.ar.com/ is that
    http://www.pandorajewellery.com.au/ in most cases
    http://www.nikeshoesoutlet.org.uk/ I’d
    http://www.handbagsoutlet.com.co/ rather
    http://www.uggbootsclearance.com.co/ be putting along “between”
    http://www.horloges-rolex.nl/ at http://www.toryburchsale.com.co/ a
    http://www.michaelkorsoutlet.ar.com/ moderate pace
    http://www.celinebags.org/ with
    http://www.bcbg-max-azria.ca/ the
    http://www.louisvuitton-outlet.com.co/ same
    http://www.designerhandbagsoutlet.com.co/ jig
    http://www.michaelkors.co.nl/ in my
    http://www.michaeljordan.com.de/ hand that I
    http://www.nike-air-max.com.se/ had
    http://www.thenorthfacejackets.in.net/ success with on
    http://www.burberry–outlet.com.co/ the http://www.prada.com.de/ docks
    http://www.cheapjerseys.us.org/ all
    http://www.maccosmetics.gr.com/ day, and
    http://www.michael-kors.com.co/ looking
    http://www.louboutin.jp.net/ for
    http://www.swarovski-online-shop.de/ that
    http://www.vans-schuhe.com.de/ unique
    http://www.michaelkorsoutletonline-sale.us.com/ cast/pitch
    http://www.cheap-uggboots.in.net/ to
    http://www.mcmhandbags.com.co/ something

  2. aw says:

    I think your article is very useful, it might be in more detail further suggest the method clearer method, can be of several categories that you created or any of several methods that should be done in the process of it, thank you very much
    http://www.lokerjobindo.com lokerius
    http://www.kerjabumn.com somone
    http://www.lokerjobindo.com/2015/10/lowongan-bumn-brantas-abipraya-persero.html I need
    http://www.kerjabumn.com/2015/10/lowongan-bumn-brantas-abipraya-persero.html beberapa
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-terbaru.html langka sebenaernua
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bumn-pt-nindya-karya.html ada rasa
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-cimb-niaga.html sama kita
    http://www.lokerjobindo.com/2015/11/info-kerja-bumn-pt-sarana-multi.html tapi sebenarnya
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-terbaru-pt-citilink.html tahukan anda
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-d3-s1-pt-hk-realtindo.html sebutan dari
    http://www.lokerjobindo.com/2015/11/info-kerja-bank-bri-frontliner.html kita adalah
    http://www.lokerjobindo.com/2015/11/info-lowongan-kerja-staf-hubungan.html anugrah yang

    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-pertamina-retail.html dapat kita
    http://www.lokerjobindo.com/2015/11/info-kerja-professional-insurance.html capai

    http://www.lokerjobindo.com/2015/11/lowongan-kerja-it-programmer.html sebenarnya
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-bca-syariah.html rahasia itu
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-danamon.html hanya ada
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-d3.html dalam sebuah cerita
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-bni-life-insurance.html tentang kita
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-pt-axa-mandiri.html yah begitulah hidup
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-sinamrmas.html hidup itu cuma sekali
    http://www.lokerjobindo.com/2015/11/lowongan-kerja-bank-mandiri-syariah.html tidak ada keduakalinya
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-bank-btn.html maksudnya cuma hidup di dunia
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-pt-astra-international.html rahasia semua kediupan
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-adira-finance.html semuanya akan

    http://www.lokerjobindo.com/2015/10/lowongan-kerja-pertamina-geothermal.html ada saatnya di mana
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-bank-bca.html semua akan melakkan
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-bank-jatim.html langkah satu persatu
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-icon-pln.html demi mengjar suksesnya
    http://www.lokerjobindo.com/2015/10/lowongan-kerja-terbaru-s1-kalbe.html rahasia hidup

  3. Lowongan Kerja Terbaru says:

    http://www.kerja-bumn.com/search/label/Lowongan%20Kerja%20BUMN">Lowongan Kerja BUMN

    http://www.kerja-bumn.com/search/label/Lowongan%20Kerja%20Bank">Lowongan Kerja BANK

    http://www.kerja-bumn.com/search/label/Lowongan%20Kerja%20S1">Lowongan Kerja S1

    http://www.kerja-bumn.com/search/label/Lowongan%20Kerja%20D3">Lowongan Kerja D3

    http://www.kerja-bumn.com/search/label/Lowongan%20Kerja%20SMA">Lowongan Kerja SMA

    http://www.kerja-bumn.com">Lowongan Kerja Terbaru

    http://www.kerja-bumn.com
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-pt-bank-mandiri-persero.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-pt-pjti-pt-pelabuhan.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-d3-s1-s2-rs-permata.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-bank-central.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-pt-indonesia.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-smasmk-koperasi-kopma-ugm.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-d3-s1-frontliner-dan-mka.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-s1-unilever-indonesia.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-d3-dan-s1-pupuk-kaltim.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-nestle-via-cdc-unsri.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-pt-hutama-karya-persero.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-funding-officer-bank-btn.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-pt-honda-prospect-motor.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-pt-yamaha.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-sarihusada.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-eni-indonesia.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-pt-inalum-persero.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-treasury-officer-pt.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-bumn-perum-lkbn-antara.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-kemenko-perekonomian.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-pt-infomedia-nusantara.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-bank-danamon-sebagai.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-adaro-energy-tbk.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-icon-pln.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-kalbe.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-teller-cimb-niaga.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-officer.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-pt-astra-international.html
    http://www.kerja-bumn.com/2015/10/lowongan-kerja-terbaru-s1-pertamina.html

  4. ali says:

    http://www.abadiesel.com/electro-pumps" title="الکتروپمپ">الکتروپمپ
    http://www.abadiesel.com/gearbox" title="گيربکس">گيربکس
    http://www.abadiesel.com/compressor/" title="کمپرسور">کمپرسور
    http://www.abadiesel.com/electromotor" title="الکتروموتور">الکتروموتور
    http://www.abadiesel.com/carwash" title="کارواش">کارواش
    http://www.abadiesel.com/generator-motor/electric-engine" title="موتور برق">موتور برق
    http://www.abadiesel.com/generator-motor/diesel-generator/" title="ديزل ژنراتور">ديزل ژنراتور