- Odbc Sql Server Driver Location Mac Os X
- Odbc Driver Location
- Odbc Drivers Location
- 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:
Make sure that you have root permission.
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
.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.
To see a list of the available installation options, execute the following command: ./install.sh.
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
.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.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
orlib-dir
), specify the command after the install option.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:
rm -f /usr/bin/sqlcmd
rm -f /usr/bin/bcp
rm -rf /opt/microsoft/msodbcsql
odbcinst -u -d -n 'ODBC Driver 11 for SQL Server'
Driver files
The ODBC driver on Linux consists of the following components:
Component | Description |
---|---|
libmsodbcsql-17.X.so.X.X or libmsodbcsql-13.X.so.X.X | The 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.rll | The accompanying resource file for the driver library. This file is installed in [driver .so directory]./share/resources/en_US/ |
msodbcsql.h | The 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.txt | The 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_NOTES | The 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-selections
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 et Oracle LinuxRed Hat Enterprise Server and Oracle Linux
SUSE Linux Enterprise ServerSUSE Linux Enterprise Server
UbuntuUbuntu
- Odbc Sql Server Driver Location Mac Os X
- Odbc Driver Location
- Odbc Drivers Location
- 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:
Make sure that you have root permission.
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
.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.
To see a list of the available installation options, execute the following command: ./install.sh.
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
.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.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
orlib-dir
), specify the command after the install option.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:
rm -f /usr/bin/sqlcmd
rm -f /usr/bin/bcp
rm -rf /opt/microsoft/msodbcsql
odbcinst -u -d -n 'ODBC Driver 11 for SQL Server'
Driver files
The ODBC driver on Linux consists of the following components:
Component | Description |
---|---|
libmsodbcsql-17.X.so.X.X or libmsodbcsql-13.X.so.X.X | The 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.rll | The accompanying resource file for the driver library. This file is installed in [driver .so directory]./share/resources/en_US/ |
msodbcsql.h | The 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.txt | The 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_NOTES | The 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-selections
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 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-selections
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
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, unixODBC
Red Hat:glibc, e2fsprogs, krb5-libs, openssl, unixODBC
- SUSE :
glibc, libuuid1, krb5, openssl, unixODBC
SUSE: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 latestmsodbcsql
.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 latestmsodbcsql
.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 latestmsodbcsql
.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:
Assurez-vous de disposer d'une autorisation d'accès à la racine.Make sure that you have root permission.
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 filemsodbcsql-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
.Accédez au répertoire
msodbcsql-11.0.2270.0
, où devrait se trouver un fichier nommé install.sh.Change to themsodbcsql-11.0.2270.0
directory and there you should see a file called install.sh.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.
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
.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.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
oulib-dir
), spécifiez-la après l'option install.If you need to specify an install command (bin-dir
orlib-dir
), specify the command after the install option.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:
rm -f /usr/bin/sqlcmd
rm -f /usr/bin/bcp
rm -rf /opt/microsoft/msodbcsql
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
ComposantComponent | DescriptionDescription |
---|---|
libmsodbcsql-17.X.so.X.X ou libmsodbcsql-13.X.so.X.Xlibmsodbcsql-17.X.so.X.X or libmsodbcsql-13.X.so.X.X | Fichier 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.rll msodbcsqlr17.rll or msodbcsqlr13.rll | Fichier 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.h | Fichier 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.txt | Fichier 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_NOTES | Fichier 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.