Return to site

Odbc Sql Server Driver Location Mac Os

broken image


Location
  1. Odbc Sql Server Driver Location Mac Os X
  2. Odbc Driver Location
  3. Odbc Drivers Location
  4. Install Sql Server Odbc Driver
-->

This article explains how to install the Microsoft ODBC Driver for SQL Server on Linux. It also includes instructions for the optional command-line tools for SQL Server (bcp and sqlcmd) and the unixODBC development headers.

The Actual SQL Server ODBC Driver lets you access your company's Microsoft SQL Server and Sybase databases from within Microsoft Excel and FileMaker Pro. Mac OS X 10.2/10.3/10.3.9/10.4 Intel.

This article provides commands for installing the ODBC driver from the bash shell. If you want to download the packages directly, see Download ODBC Driver for SQL Server.

Microsoft ODBC 17

The following sections explain how to install the Microsoft ODBC driver 17 from the bash shell for different Linux distributions.

https://weiboolitppick1987.mystrikingly.com/blog/how-to-boot-camp-windows-10-on-mac. Important

If you installed the v17 msodbcsql package that was briefly available, you should remove it before installing the msodbcsql17 package. This will avoid conflicts. The msodbcsql17 package can be installed side by side with the msodbcsql v13 package.

Alpine Linux

Note

Driver version 17.5 or higher is required for Alpine support.

Debian

Note

You can substitute setting the environment variable 'ACCEPT_EULA' with setting the debconf variable 'msodbcsql/ACCEPT_EULA' instead: echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selections

Red Hat Enterprise Server and Oracle Linux

SUSE Linux Enterprise Server

Ubuntu

Note

  • Driver version 17.2 or higher is required for Ubuntu 18.04 support.
  • Driver version 17.3 or higher is required for Ubuntu 18.10 support.

Note

You can substitute setting the environment variable 'ACCEPT_EULA' with setting the debconf variable 'msodbcsql/ACCEPT_EULA' instead: echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selections

Previous versions

The following sections provide instructions for installing previous versions of the Microsoft ODBC driver on Linux. The following driver versions are covered:

ODBC 13.1

The following sections explain how to install the Microsoft ODBC driver 13.1 from the bash shell for different Linux distributions.

Debian 8

RedHat Enterprise Server 6

RedHat Enterprise Server 7

SUSE Linux Enterprise Server 11

SUSE Linux Enterprise Server 12

Ubuntu 15.10

Ubuntu 16.04

Ubuntu 16.10

ODBC 13

The following sections explain how to install the Microsoft ODBC driver 13 from the bash shell for different Linux distributions.

RedHat Enterprise Server 6

RedHat Enterprise Server 7

Ubuntu 15.10

Ubuntu 16.04

SUSE Linux Enterprise Server 12

Offline installation

If you prefer/require the Microsoft ODBC Driver 13 to be installed on a computer with no internet connection, you will need to resolve package dependencies manually. The Microsoft ODBC Driver 13 has the following direct dependencies:

  • Ubuntu: libc6 (>= 2.21), libstdc++6 (>= 4.9), libkrb5-3, libcurl3, openssl, debconf (>= 0.5), unixodbc (>= 2.3.1-1)
  • Red Hat: glibc, e2fsprogs, krb5-libs, openssl, unixODBC
  • SUSE: glibc, libuuid1, krb5, openssl, unixODBC

Each of these packages in turn has their own dependencies, which may or may not be present on the system. For a general solution to this issue, refer to your distribution's package manager documentation: Redhat, Ubuntu, and SUSE

It is also common to manually download all the dependent packages and place them together on the installation computer, then manually install each package in turn, finishing with the Microsoft ODBC Driver 13 package.

Redhat Linux Enterprise Server 7

  • Download the latest msodbcsql.rpm from https://packages.microsoft.com/rhel/7/prod/.
  • Install dependencies and the driver.

Ubuntu 16.04

  • Download the latest msodbcsql.deb from https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql/.
  • Install dependencies and the driver.

SUSE Linux Enterprise Server 12

  • Download the latest msodbcsql.rpm from https://packages.microsoft.com/sles/12/prod/.
  • Install the dependencies and the driver.

After you have completed the package installation, you can verify that the Microsoft ODBC Driver 13 can find all its dependencies by running ldd and inspecting its output for missing libraries:

ODBC 11

The following sections explain how to install the Microsoft ODBC driver 11 on Linux. Before you can use the driver, install the unixODBC driver manager. For more information, see Installing the Driver Manager.

In order to run Mac OS X Applications that leverage the CUDA architecture of certain NVIDIA graphics cards, users will need to download and install the 7.0.64 driver for Mac located here. New in Release 346.02.03f01: Graphics driver updated for Mac OS X Yosemite 10.10.4 (14E46). Apple TV Firmware 13.4.6 Build 17L570 / 13.4.8 Build 17M61 Beta 4 / 14 Build 18J5331g Beta 2. An easy to install software package that helps you update the firmware of your Apple TV device to. Learn about AppleCare+ and the Apple limited warranty coverage, start a service request for your Mac, and find out how to prepare your Mac for service. Learn more about repairs. Search for more topics. Search Support Clear Search. Get AppleCare+ for Mac. With AppleCare+, you're covered. Get accidental damage coverage and 24/7 priority access. http://weiboolitppick1987.mystrikingly.com/blog/add-a-blog-post-title-e3d5bae0-0c68-4948-b0e9-649c4c3346b2.

Installation Steps

Important

These instructions refer to msodbcsql-11.0.2270.0.tar.gz Hp 8600 deskjet mac os x driver. , which is installation file for Red Hat Linux. If you are installing the Preview for SUSE Linux, the file name is msodbcsql-11.0.2260.0.tar.gz.

To install the driver:

  1. Make sure that you have root permission.

  2. Change to the directory where the download placed the file msodbcsql-11.0.2270.0.tar.gz. Make sure that you have the *.tar.gz file that matches your version of Linux. To extract the files, execute the following command, tar xvzf msodbcsql-11.0.2270.0.tar.gz.

  3. Change to the msodbcsql-11.0.2270.0 directory and there you should see a file called install.sh.

    Download the latest drivers, firmware, and software for your HP Scanjet 8200c Scanner series.This is HP's official website that will help automatically detect and download the correct drivers free of cost for your HP Computing and Printing products for Windows and Mac operating system. Hp scanjet 8200 driver mac os x.

  4. To see a list of the available installation options, execute the following command: ./install.sh.

  5. Make a backup of odbcinst.ini. The driver installation updates odbcinst.ini. odbcinst.ini contains the list of drivers that are registered with the unixODBC Driver Manager. To discover the location of odbcinst.ini on your computer, execute the following command: odbc_config --odbcinstini.

  6. Before you install the driver, execute the following command: ./install.sh verify. The output of ./install.sh verify reports if your computer has the required software to support the ODBC driver on Linux.

  7. When you are ready to install the ODBC driver on Linux, execute the command: ./install.sh install. If you need to specify an install command (bin-dir or lib-dir), specify the command after the install option.

  8. After reviewing the license agreement, type YES to continue with the installation.

Installation puts the driver in /opt/microsoft/msodbcsql/11.0.2270.0. The driver and its support files must be in /opt/microsoft/msodbcsql/11.0.2270.0.

To verify that the Microsoft ODBC driver on Linux was registered successfully, execute the following command: odbcinst -q -d -n 'ODBC Driver 11 for SQL Server'.

Uninstall

You can uninstall the ODBC driver 11 on Linux by executing the following commands:

  1. rm -f /usr/bin/sqlcmd

  2. rm -f /usr/bin/bcp

  3. rm -rf /opt/microsoft/msodbcsql

  4. odbcinst -u -d -n 'ODBC Driver 11 for SQL Server'

Driver files

The ODBC driver on Linux consists of the following components:

ComponentDescription
libmsodbcsql-17.X.so.X.X or libmsodbcsql-13.X.so.X.XThe shared object (so) dynamic library file that contains all of the driver's functionality. This file is installed in /opt/microsoft/msodbcsql17/lib64/ for the Driver 17 and in /opt/microsoft/msodbcsql/lib64/ for Driver 13.
msodbcsqlr17.rll or msodbcsqlr13.rllThe accompanying resource file for the driver library. This file is installed in [driver .so directory]./share/resources/en_US/
msodbcsql.hThe header file that contains all of the new definitions needed to use the driver.
Note: You cannot reference msodbcsql.h and odbcss.h in the same program.
msodbcsql.h is installed in /opt/microsoft/msodbcsql17/include/ for Driver 17 and in /opt/microsoft/msodbcsql/include/ for Driver 13.
LICENSE.txtThe text file that contains the terms of the End-User License Agreement. This file is placed in /usr/share/doc/msodbcsql17/ for Driver 17 and in /usr/share/doc/msodbcsql/ for Driver 13.
RELEASE_NOTESThe text file that contains release notes. This file is placed in /usr/share/doc/msodbcsql17/ for Driver 17 and in /usr/share/doc/msodbcsql/ for Driver 13.

Resource file loading

The driver needs to load the resource file in order to function. This file is called msodbcsqlr17.rll or msodbcsqlr13.rll depending on the driver version. The location of the .rll file is relative to the location of the driver itself (so or dylib), as noted in the table above. As of version 17.1 the driver will also attempt to load the .rll from the default directory if loading from the relative path fails. The default resource file path on Linux is /opt/microsoft/msodbcsql17/share/resources/en_US/.

Troubleshooting

If you are unable to make a connection to SQL Server using the ODBC driver, see the known issues article on troubleshooting connection problems.

Next steps

After installing the driver, you can try the C++ ODBC example application. For more information about developing ODBC applications, see Developing Applications.

For more information, see the ODBC driver release notes and system requirements.

-->

Cet article explique comment installer Microsoft ODBC Driver for SQL Server sur Linux.This article explains how to install the Microsoft ODBC Driver for SQL Server on Linux.Il contient également des instructions pour les outils en ligne de commande facultatifs pour SQL Server (bcp et sqlcmd) et les en-têtes de développement unixODBC.It also includes instructions for the optional command-line tools for SQL Server (bcp and sqlcmd) and the unixODBC development headers.

Cet article fournit des commandes pour installer le pilote ODBC à partir de l'interpréteur de commandes bash.This article provides commands for installing the ODBC driver from the bash shell.Si vous souhaitez télécharger les packages directement, consultez Télécharger ODBC Driver for SQL Server.If you want to download the packages directly, see Download ODBC Driver for SQL Server.

Microsoft ODBC 17Microsoft ODBC 17

Les sections suivantes expliquent comment installer le pilote Microsoft ODBC 17 à partir de l'interpréteur de commandes bash pour différentes distributions de Linux.The following sections explain how to install the Microsoft ODBC driver 17 from the bash shell for different Linux distributions.

Important

Si vous avez installé le package msodbcsql v17 qui n'a pas été disponible longtemps, vous devez le supprimer avant d'installer le package msodbcsql17.If you installed the v17 msodbcsql package that was briefly available, you should remove it before installing the msodbcsql17 package.Cette opération évitera les conflits.This will avoid conflicts.Le package msodbcsql17 peut être installé côte à côte avec le package msodbcsql v13.The msodbcsql17 package can be installed side by side with the msodbcsql v13 package.

Alpine LinuxAlpine Linux

Notes

Le pilote version 17.5 ou ultérieure est requise pour la prise en charge d'Alpine.Driver version 17.5 or higher is required for Alpine support.

DebianDebian

Notes

Vous pouvez remplacer la variable d'environnement 'ACCEPT_EULA' par la variable debconf 'msodbcsql/ACCEPT_EULA' : echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selectionsYou can substitute setting the environment variable 'ACCEPT_EULA' with setting the debconf variable 'msodbcsql/ACCEPT_EULA' instead: echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selections

Red Hat Enterprise Server et Oracle LinuxRed Hat Enterprise Server and Oracle Linux

SUSE Linux Enterprise ServerSUSE Linux Enterprise Server

UbuntuUbuntu

Odbc sql server driver location mac os 10
  1. Odbc Sql Server Driver Location Mac Os X
  2. Odbc Driver Location
  3. Odbc Drivers Location
  4. Install Sql Server Odbc Driver
-->

This article explains how to install the Microsoft ODBC Driver for SQL Server on Linux. It also includes instructions for the optional command-line tools for SQL Server (bcp and sqlcmd) and the unixODBC development headers.

The Actual SQL Server ODBC Driver lets you access your company's Microsoft SQL Server and Sybase databases from within Microsoft Excel and FileMaker Pro. Mac OS X 10.2/10.3/10.3.9/10.4 Intel.

This article provides commands for installing the ODBC driver from the bash shell. If you want to download the packages directly, see Download ODBC Driver for SQL Server.

Microsoft ODBC 17

The following sections explain how to install the Microsoft ODBC driver 17 from the bash shell for different Linux distributions.

https://weiboolitppick1987.mystrikingly.com/blog/how-to-boot-camp-windows-10-on-mac. Important

If you installed the v17 msodbcsql package that was briefly available, you should remove it before installing the msodbcsql17 package. This will avoid conflicts. The msodbcsql17 package can be installed side by side with the msodbcsql v13 package.

Alpine Linux

Note

Driver version 17.5 or higher is required for Alpine support.

Debian

Note

You can substitute setting the environment variable 'ACCEPT_EULA' with setting the debconf variable 'msodbcsql/ACCEPT_EULA' instead: echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selections

Red Hat Enterprise Server and Oracle Linux

SUSE Linux Enterprise Server

Ubuntu

Note

  • Driver version 17.2 or higher is required for Ubuntu 18.04 support.
  • Driver version 17.3 or higher is required for Ubuntu 18.10 support.

Note

You can substitute setting the environment variable 'ACCEPT_EULA' with setting the debconf variable 'msodbcsql/ACCEPT_EULA' instead: echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selections

Previous versions

The following sections provide instructions for installing previous versions of the Microsoft ODBC driver on Linux. The following driver versions are covered:

ODBC 13.1

The following sections explain how to install the Microsoft ODBC driver 13.1 from the bash shell for different Linux distributions.

Debian 8

RedHat Enterprise Server 6

RedHat Enterprise Server 7

SUSE Linux Enterprise Server 11

SUSE Linux Enterprise Server 12

Ubuntu 15.10

Ubuntu 16.04

Ubuntu 16.10

ODBC 13

The following sections explain how to install the Microsoft ODBC driver 13 from the bash shell for different Linux distributions.

RedHat Enterprise Server 6

RedHat Enterprise Server 7

Ubuntu 15.10

Ubuntu 16.04

SUSE Linux Enterprise Server 12

Offline installation

If you prefer/require the Microsoft ODBC Driver 13 to be installed on a computer with no internet connection, you will need to resolve package dependencies manually. The Microsoft ODBC Driver 13 has the following direct dependencies:

  • Ubuntu: libc6 (>= 2.21), libstdc++6 (>= 4.9), libkrb5-3, libcurl3, openssl, debconf (>= 0.5), unixodbc (>= 2.3.1-1)
  • Red Hat: glibc, e2fsprogs, krb5-libs, openssl, unixODBC
  • SUSE: glibc, libuuid1, krb5, openssl, unixODBC

Each of these packages in turn has their own dependencies, which may or may not be present on the system. For a general solution to this issue, refer to your distribution's package manager documentation: Redhat, Ubuntu, and SUSE

It is also common to manually download all the dependent packages and place them together on the installation computer, then manually install each package in turn, finishing with the Microsoft ODBC Driver 13 package.

Redhat Linux Enterprise Server 7

  • Download the latest msodbcsql.rpm from https://packages.microsoft.com/rhel/7/prod/.
  • Install dependencies and the driver.

Ubuntu 16.04

  • Download the latest msodbcsql.deb from https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql/.
  • Install dependencies and the driver.

SUSE Linux Enterprise Server 12

  • Download the latest msodbcsql.rpm from https://packages.microsoft.com/sles/12/prod/.
  • Install the dependencies and the driver.

After you have completed the package installation, you can verify that the Microsoft ODBC Driver 13 can find all its dependencies by running ldd and inspecting its output for missing libraries:

ODBC 11

The following sections explain how to install the Microsoft ODBC driver 11 on Linux. Before you can use the driver, install the unixODBC driver manager. For more information, see Installing the Driver Manager.

In order to run Mac OS X Applications that leverage the CUDA architecture of certain NVIDIA graphics cards, users will need to download and install the 7.0.64 driver for Mac located here. New in Release 346.02.03f01: Graphics driver updated for Mac OS X Yosemite 10.10.4 (14E46). Apple TV Firmware 13.4.6 Build 17L570 / 13.4.8 Build 17M61 Beta 4 / 14 Build 18J5331g Beta 2. An easy to install software package that helps you update the firmware of your Apple TV device to. Learn about AppleCare+ and the Apple limited warranty coverage, start a service request for your Mac, and find out how to prepare your Mac for service. Learn more about repairs. Search for more topics. Search Support Clear Search. Get AppleCare+ for Mac. With AppleCare+, you're covered. Get accidental damage coverage and 24/7 priority access. http://weiboolitppick1987.mystrikingly.com/blog/add-a-blog-post-title-e3d5bae0-0c68-4948-b0e9-649c4c3346b2.

Installation Steps

Important

These instructions refer to msodbcsql-11.0.2270.0.tar.gz Hp 8600 deskjet mac os x driver. , which is installation file for Red Hat Linux. If you are installing the Preview for SUSE Linux, the file name is msodbcsql-11.0.2260.0.tar.gz.

To install the driver:

  1. Make sure that you have root permission.

  2. Change to the directory where the download placed the file msodbcsql-11.0.2270.0.tar.gz. Make sure that you have the *.tar.gz file that matches your version of Linux. To extract the files, execute the following command, tar xvzf msodbcsql-11.0.2270.0.tar.gz.

  3. Change to the msodbcsql-11.0.2270.0 directory and there you should see a file called install.sh.

    Download the latest drivers, firmware, and software for your HP Scanjet 8200c Scanner series.This is HP's official website that will help automatically detect and download the correct drivers free of cost for your HP Computing and Printing products for Windows and Mac operating system. Hp scanjet 8200 driver mac os x.

  4. To see a list of the available installation options, execute the following command: ./install.sh.

  5. Make a backup of odbcinst.ini. The driver installation updates odbcinst.ini. odbcinst.ini contains the list of drivers that are registered with the unixODBC Driver Manager. To discover the location of odbcinst.ini on your computer, execute the following command: odbc_config --odbcinstini.

  6. Before you install the driver, execute the following command: ./install.sh verify. The output of ./install.sh verify reports if your computer has the required software to support the ODBC driver on Linux.

  7. When you are ready to install the ODBC driver on Linux, execute the command: ./install.sh install. If you need to specify an install command (bin-dir or lib-dir), specify the command after the install option.

  8. After reviewing the license agreement, type YES to continue with the installation.

Installation puts the driver in /opt/microsoft/msodbcsql/11.0.2270.0. The driver and its support files must be in /opt/microsoft/msodbcsql/11.0.2270.0.

To verify that the Microsoft ODBC driver on Linux was registered successfully, execute the following command: odbcinst -q -d -n 'ODBC Driver 11 for SQL Server'.

Uninstall

You can uninstall the ODBC driver 11 on Linux by executing the following commands:

  1. rm -f /usr/bin/sqlcmd

  2. rm -f /usr/bin/bcp

  3. rm -rf /opt/microsoft/msodbcsql

  4. odbcinst -u -d -n 'ODBC Driver 11 for SQL Server'

Driver files

The ODBC driver on Linux consists of the following components:

ComponentDescription
libmsodbcsql-17.X.so.X.X or libmsodbcsql-13.X.so.X.XThe shared object (so) dynamic library file that contains all of the driver's functionality. This file is installed in /opt/microsoft/msodbcsql17/lib64/ for the Driver 17 and in /opt/microsoft/msodbcsql/lib64/ for Driver 13.
msodbcsqlr17.rll or msodbcsqlr13.rllThe accompanying resource file for the driver library. This file is installed in [driver .so directory]./share/resources/en_US/
msodbcsql.hThe header file that contains all of the new definitions needed to use the driver.
Note: You cannot reference msodbcsql.h and odbcss.h in the same program.
msodbcsql.h is installed in /opt/microsoft/msodbcsql17/include/ for Driver 17 and in /opt/microsoft/msodbcsql/include/ for Driver 13.
LICENSE.txtThe text file that contains the terms of the End-User License Agreement. This file is placed in /usr/share/doc/msodbcsql17/ for Driver 17 and in /usr/share/doc/msodbcsql/ for Driver 13.
RELEASE_NOTESThe text file that contains release notes. This file is placed in /usr/share/doc/msodbcsql17/ for Driver 17 and in /usr/share/doc/msodbcsql/ for Driver 13.

Resource file loading

The driver needs to load the resource file in order to function. This file is called msodbcsqlr17.rll or msodbcsqlr13.rll depending on the driver version. The location of the .rll file is relative to the location of the driver itself (so or dylib), as noted in the table above. As of version 17.1 the driver will also attempt to load the .rll from the default directory if loading from the relative path fails. The default resource file path on Linux is /opt/microsoft/msodbcsql17/share/resources/en_US/.

Troubleshooting

If you are unable to make a connection to SQL Server using the ODBC driver, see the known issues article on troubleshooting connection problems.

Next steps

After installing the driver, you can try the C++ ODBC example application. For more information about developing ODBC applications, see Developing Applications.

For more information, see the ODBC driver release notes and system requirements.

-->

Cet article explique comment installer Microsoft ODBC Driver for SQL Server sur Linux.This article explains how to install the Microsoft ODBC Driver for SQL Server on Linux.Il contient également des instructions pour les outils en ligne de commande facultatifs pour SQL Server (bcp et sqlcmd) et les en-têtes de développement unixODBC.It also includes instructions for the optional command-line tools for SQL Server (bcp and sqlcmd) and the unixODBC development headers.

Cet article fournit des commandes pour installer le pilote ODBC à partir de l'interpréteur de commandes bash.This article provides commands for installing the ODBC driver from the bash shell.Si vous souhaitez télécharger les packages directement, consultez Télécharger ODBC Driver for SQL Server.If you want to download the packages directly, see Download ODBC Driver for SQL Server.

Microsoft ODBC 17Microsoft ODBC 17

Les sections suivantes expliquent comment installer le pilote Microsoft ODBC 17 à partir de l'interpréteur de commandes bash pour différentes distributions de Linux.The following sections explain how to install the Microsoft ODBC driver 17 from the bash shell for different Linux distributions.

Important

Si vous avez installé le package msodbcsql v17 qui n'a pas été disponible longtemps, vous devez le supprimer avant d'installer le package msodbcsql17.If you installed the v17 msodbcsql package that was briefly available, you should remove it before installing the msodbcsql17 package.Cette opération évitera les conflits.This will avoid conflicts.Le package msodbcsql17 peut être installé côte à côte avec le package msodbcsql v13.The msodbcsql17 package can be installed side by side with the msodbcsql v13 package.

Alpine LinuxAlpine Linux

Notes

Le pilote version 17.5 ou ultérieure est requise pour la prise en charge d'Alpine.Driver version 17.5 or higher is required for Alpine support.

DebianDebian

Notes

Vous pouvez remplacer la variable d'environnement 'ACCEPT_EULA' par la variable debconf 'msodbcsql/ACCEPT_EULA' : echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selectionsYou can substitute setting the environment variable 'ACCEPT_EULA' with setting the debconf variable 'msodbcsql/ACCEPT_EULA' instead: echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selections

Red Hat Enterprise Server et Oracle LinuxRed Hat Enterprise Server and Oracle Linux

SUSE Linux Enterprise ServerSUSE Linux Enterprise Server

UbuntuUbuntu

Notes

  • Le pilote version 17.2 ou ultérieure est requise pour la prise en charge d'Ubuntu 18.04.Driver version 17.2 or higher is required for Ubuntu 18.04 support.
  • Le pilote version 17.3 ou ultérieure est requise pour la prise en charge d'Ubuntu 18.10.Driver version 17.3 or higher is required for Ubuntu 18.10 support.

Notes

Vous pouvez remplacer la variable d'environnement 'ACCEPT_EULA' par la variable debconf 'msodbcsql/ACCEPT_EULA' : echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selectionsYou can substitute setting the environment variable 'ACCEPT_EULA' with setting the debconf variable 'msodbcsql/ACCEPT_EULA' instead: echo msodbcsql17 msodbcsql/ACCEPT_EULA boolean true | sudo debconf-set-selections

Versions précédentesPrevious versions

Les sections suivantes fournissent des instructions pour l'installation des versions précédentes du pilote Microsoft ODBC sur Linux.The following sections provide instructions for installing previous versions of the Microsoft ODBC driver on Linux.Les versions du pilote suivantes sont abordées :The following driver versions are covered:

ODBC 13.1ODBC 13.1

Les sections suivantes expliquent comment installer le pilote Microsoft ODBC 13.1 à partir de l'interpréteur de commandes bash pour différentes distributions de Linux.The following sections explain how to install the Microsoft ODBC driver 13.1 from the bash shell for different Linux distributions.

Debian 8Debian 8

RedHat Enterprise Server 6RedHat Enterprise Server 6

RedHat Enterprise Server 7RedHat Enterprise Server 7

SUSE Linux Enterprise Server 11SUSE Linux Enterprise Server 11

SUSE Linux Enterprise Server 12SUSE Linux Enterprise Server 12

Ubuntu 15.10Ubuntu 15.10

Ubuntu 16.04Ubuntu 16.04

Ubuntu 16.10Ubuntu 16.10

ODBC 13ODBC 13

Les sections suivantes expliquent comment installer le pilote Microsoft ODBC 13 à partir de l'interpréteur de commandes bash pour différentes distributions de Linux.The following sections explain how to install the Microsoft ODBC driver 13 from the bash shell for different Linux distributions.

RedHat Enterprise Server 6RedHat Enterprise Server 6

RedHat Enterprise Server 7RedHat Enterprise Server 7

Ubuntu 15.10Ubuntu 15.10

Ubuntu 16.04Ubuntu 16.04

SUSE Linux Enterprise Server 12SUSE Linux Enterprise Server 12

Installation hors connexionOffline installation

Si vous préférez/nécessitez que MicrosoftMicrosoft ODBC Driver 13 soit installé sur un ordinateur sans connexion Internet, vous devez résoudre manuellement les dépendances de package.If you prefer/require the MicrosoftMicrosoft ODBC Driver 13 to be installed on a computer with no internet connection, you will need to resolve package dependencies manually.MicrosoftMicrosoft ODBC Driver 13 a les dépendances directes suivantes :The MicrosoftMicrosoft ODBC Driver 13 has the following direct dependencies:

  • Ubuntu : libc6 (>= 2.21), libstdc++6 (>= 4.9), libkrb5-3, libcurl3, openssl, debconf (>= 0.5), unixodbc (>= 2.3.1-1)Ubuntu: libc6 (>= 2.21), libstdc++6 (>= 4.9), libkrb5-3, libcurl3, openssl, debconf (>= 0.5), unixodbc (>= 2.3.1-1)
  • Red Hat : glibc, e2fsprogs, krb5-libs, openssl, unixODBCRed Hat: glibc, e2fsprogs, krb5-libs, openssl, unixODBC
  • SUSE : glibc, libuuid1, krb5, openssl, unixODBCSUSE: glibc, libuuid1, krb5, openssl, unixODBC

Chacun de ces packages a ses propres dépendances, qui peuvent ou non être présentes sur le système.Each of these packages in turn has their own dependencies, which may or may not be present on the system.Pour une solution générale à ce problème, reportez-vous à la documentation du gestionnaire de package de votre distribution : Redhat, Ubuntu et SUSEFor a general solution to this issue, refer to your distribution's package manager documentation: Redhat, Ubuntu, and SUSE

Il est également courant de télécharger manuellement tous les packages dépendants et de les placer ensemble sur l'ordinateur d'installation, puis d'installer manuellement chaque package tour à tour, en terminant par le package MicrosoftMicrosoft ODBC Driver 13.It is also common to manually download all the dependent packages and place them together on the installation computer, then manually install each package in turn, finishing with the MicrosoftMicrosoft ODBC Driver 13 package.

Odbc Sql Server Driver Location Mac Os X

Redhat Linux Enterprise Server 7Redhat Linux Enterprise Server 7

  • Téléchargez le dernier package msodbcsql.rpm à partir de https://packages.microsoft.com/rhel/7/prod/.Download the latest msodbcsql.rpm from https://packages.microsoft.com/rhel/7/prod/.
  • Installez les dépendances et le pilote.Install dependencies and the driver.

Ubuntu 16.04Ubuntu 16.04

  • Téléchargez le dernier package msodbcsql.deb à partir de https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql/.Download the latest msodbcsql.deb from https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql/.
  • Installez les dépendances et le pilote.Install dependencies and the driver.

SUSE Linux Enterprise Server 12SUSE Linux Enterprise Server 12

  • Téléchargez le dernier package msodbcsql.rpm à partir de https://packages.microsoft.com/sles/12/prod/.Download the latest msodbcsql.rpm from https://packages.microsoft.com/sles/12/prod/.
  • Installez les dépendances et le pilote.Install the dependencies and the driver.

Une fois l'installation du package terminée, vous pouvez vérifier que MicrosoftMicrosoft ODBC Driver 13 peut trouver toutes ses dépendances en exécutant ldd et en inspectant sa sortie pour déterminer les bibliothèques manquantes :After you have completed the package installation, you can verify that the MicrosoftMicrosoft ODBC Driver 13 can find all its dependencies by running ldd and inspecting its output for missing libraries:

ODBC 11ODBC 11

Les sections suivantes expliquent comment installer le pilote Microsoft ODBC 11 sur Linux.The following sections explain how to install the Microsoft ODBC driver 11 on Linux.Avant d'utiliser le pilote, installez le Gestionnaire de pilotes unixODBC.Before you can use the driver, install the unixODBC driver manager.Pour plus d'informations, consultez Installation du Gestionnaire de pilotes.For more information, see Installing the Driver Manager.

Étapes d'installationInstallation Steps

Important

Ces instructions font référence à msodbcsql-11.0.2270.0.tar.gz, qui est le fichier d'installation pour Red Hat Linux.These instructions refer to msodbcsql-11.0.2270.0.tar.gz, which is installation file for Red Hat Linux.Si vous installez la préversion pour SUSE Linux, le nom du fichier est msodbcsql-11.0.2260.0.tar.gz.If you are installing the Preview for SUSE Linux, the file name is msodbcsql-11.0.2260.0.tar.gz.

Odbc Driver Location

Pour installer le pilote :To install the driver:

  1. Assurez-vous de disposer d'une autorisation d'accès à la racine.Make sure that you have root permission.

  2. Accédez au répertoire où le téléchargement a placé le fichier msodbcsql-11.0.2270.0.tar.gz.Change to the directory where the download placed the file msodbcsql-11.0.2270.0.tar.gz.Assurez-vous de disposer du fichier *.tar.gz correspondant à votre version de Linux.Make sure that you have the *.tar.gz file that matches your version of Linux.Pour extraire les fichiers, exécutez la commande suivante : tar xvzf msodbcsql-11.0.2270.0.tar.gz.To extract the files, execute the following command, tar xvzf msodbcsql-11.0.2270.0.tar.gz.

  3. Accédez au répertoire msodbcsql-11.0.2270.0, où devrait se trouver un fichier nommé install.sh.Change to the msodbcsql-11.0.2270.0 directory and there you should see a file called install.sh.

  4. Pour afficher la liste des options d'installation disponibles, exécutez la commande suivante : ./install.sh.To see a list of the available installation options, execute the following command: ./install.sh.

  5. Effectuez une sauvegarde de odbcinst.ini.Make a backup of odbcinst.ini.L'installation du pilote met à jour odbcinst.ini.The driver installation updates odbcinst.ini.odbcinst.ini contient la liste des pilotes enregistrés auprès du Gestionnaire de pilotes unixODBC.odbcinst.ini contains the list of drivers that are registered with the unixODBC Driver Manager.Pour découvrir l'emplacement du fichier odbcinst.ini sur votre ordinateur, exécutez la commande suivante : odbc_config --odbcinstini.To discover the location of odbcinst.ini on your computer, execute the following command: odbc_config --odbcinstini.

  6. Avant d'installer le pilote, exécutez la commande suivante : ./install.sh verify.Before you install the driver, execute the following command: ./install.sh verify.La sortie de ./install.sh verify indique si votre ordinateur dispose des logiciels requis pour prendre en charge le pilote ODBC sur Linux.The output of ./install.sh verify reports if your computer has the required software to support the ODBC driver on Linux.

  7. Quand vous êtes prêt à installer le pilote ODBC sur Linux, exécutez la commande suivante : ./install.sh install.When you are ready to install the ODBC driver on Linux, execute the command: ./install.sh install.Si vous devez spécifier une commande d'installation (bin-dir ou lib-dir), spécifiez-la après l'option install.If you need to specify an install command (bin-dir or lib-dir), specify the command after the install option.

  8. Après avoir examiné le contrat de licence, tapez YES pour poursuivre l'installation.After reviewing the license agreement, type YES to continue with the installation.

L'installation place le pilote dans /opt/microsoft/msodbcsql/11.0.2270.0.Installation puts the driver in /opt/microsoft/msodbcsql/11.0.2270.0.Le pilote et ses fichiers associés doivent être dans /opt/microsoft/msodbcsql/11.0.2270.0.The driver and its support files must be in /opt/microsoft/msodbcsql/11.0.2270.0.

Worked very well. http://weiboolitppick1987.mystrikingly.com/blog/.

Pour vérifier que le pilote Microsoft ODBC sur Linux a été inscrit correctement, exécutez la commande suivante : odbcinst -q -d -n 'ODBC Driver 11 for SQL Server'.To verify that the Microsoft ODBC driver on Linux was registered successfully, execute the following command: odbcinst -q -d -n 'ODBC Driver 11 for SQL Server'.

Odbc Drivers Location

Désinstaller l'interfaceUninstall

Vous pouvez désinstaller le pilote ODBC 11 sur Linux, en exécutant les commandes suivantes :You can uninstall the ODBC driver 11 on Linux by executing the following commands:

  1. rm -f /usr/bin/sqlcmd

  2. rm -f /usr/bin/bcp

  3. rm -rf /opt/microsoft/msodbcsql

  4. odbcinst -u -d -n 'ODBC Driver 11 for SQL Server'

Fichiers de piloteDriver files

Le pilote ODBC sur Linux est constitué des composants suivants :The ODBC driver on Linux consists of the following components:

Install Sql Server Odbc Driver

ComposantComponentDescriptionDescription
libmsodbcsql-17.X.so.X.X ou libmsodbcsql-13.X.so.X.Xlibmsodbcsql-17.X.so.X.X or libmsodbcsql-13.X.so.X.XFichier bibliothèque dynamique (so) d'objets partagés contenant l'ensemble des fonctionnalités du pilote.The shared object (so) dynamic library file that contains all of the driver's functionality.Ce fichier est installé dans /opt/microsoft/msodbcsql17/lib64/ pour Driver 17 et dans /opt/microsoft/msodbcsql/lib64/ pour Driver 13.This file is installed in /opt/microsoft/msodbcsql17/lib64/ for the Driver 17 and in /opt/microsoft/msodbcsql/lib64/ for Driver 13.
msodbcsqlr17.rll ou msodbcsqlr13.rllmsodbcsqlr17.rll or msodbcsqlr13.rllFichier de ressources qui accompagne la bibliothèque du pilote.The accompanying resource file for the driver library.Ce fichier est installé dans [driver .so directory]./share/resources/en_US/This file is installed in [driver .so directory]./share/resources/en_US/
msodbcsql.hmsodbcsql.hFichier d'en-tête qui contient toutes les nouvelles définitions nécessaires à l'utilisation du pilote.The header file that contains all of the new definitions needed to use the driver.
Remarque : Vous ne pouvez pas référencer msodbcsql.h et odbcss.h dans le même programme.Note: You cannot reference msodbcsql.h and odbcss.h in the same program.
msodbcsql.h est installé dans /opt/microsoft/msodbcsql17/include/ pour Driver 17 et dans /opt/microsoft/msodbcsql/include/ pour Driver 13.msodbcsql.h is installed in /opt/microsoft/msodbcsql17/include/ for Driver 17 and in /opt/microsoft/msodbcsql/include/ for Driver 13.
LICENSE.txtLICENSE.txtFichier texte qui contient les termes du contrat de licence utilisateur final.The text file that contains the terms of the End-User License Agreement.Ce fichier est placé dans /usr/share/doc/msodbcsql17/ pour Driver 17 et dans /usr/share/doc/msodbcsql/ pour Driver 13.This file is placed in /usr/share/doc/msodbcsql17/ for Driver 17 and in /usr/share/doc/msodbcsql/ for Driver 13.
RELEASE_NOTESRELEASE_NOTESFichier texte qui contient les notes de publication.The text file that contains release notes.Ce fichier est placé dans /usr/share/doc/msodbcsql17/ pour Driver 17 et dans /usr/share/doc/msodbcsql/ pour Driver 13.This file is placed in /usr/share/doc/msodbcsql17/ for Driver 17 and in /usr/share/doc/msodbcsql/ for Driver 13.

Chargement du fichier de ressourcesResource file loading

Le pilote doit charger le fichier de ressources pour pouvoir fonctionner.The driver needs to load the resource file in order to function.Ce fichier est appelé msodbcsqlr17.rll ou msodbcsqlr13.rll selon la version du pilote.This file is called msodbcsqlr17.rll or msodbcsqlr13.rll depending on the driver version.L'emplacement du fichier .rll est relatif à l'emplacement du pilote lui-même (so ou dylib), comme indiqué dans le tableau ci-dessus.The location of the .rll file is relative to the location of the driver itself (so or dylib), as noted in the table above.Depuis la version 17.1, le pilote peut aussi essayer de charger le fichier .rll à partir du répertoire par défaut si le chargement échoue à partir du chemin d'accès relatif.As of version 17.1 the driver will also attempt to load the .rll from the default directory if loading from the relative path fails.Le chemin du fichier de ressources par défaut sur Linux est /opt/microsoft/msodbcsql17/share/resources/en_US/.The default resource file path on Linux is /opt/microsoft/msodbcsql17/share/resources/en_US/.

DépannageTroubleshooting

Si vous ne parvenez pas à établir de connexion à SQL Server à l'aide du pilote ODBC, consultez l'article sur la résolution des problèmes de connexion.If you are unable to make a connection to SQL Server using the ODBC driver, see the known issues article on troubleshooting connection problems.

Étapes suivantesNext steps

Après avoir installé le pilote, vous pouvez essayer l'exemple d'application ODBC C++.After installing the driver, you can try the C++ ODBC example application.Pour plus d'informations sur le développement d'applications ODBC, consultez Développement d'applications.For more information about developing ODBC applications, see Developing Applications.

Pour plus d'informations, consultez les notes de publication et la configuration système requise du pilote ODBC.For more information, see the ODBC driver release notes and system requirements.





broken image