在 Linux Redhat/CentOS 上为 msodbcsql17 安装 unixODBC >= 2.3.1 [英] Install unixODBC >= 2.3.1 on Linux Redhat/CentOS for msodbcsql17

问题描述

我尝试使用 CentOS/RedHat (Linux) 在 AWS EC2 上安装 msodbcsql17.

I try to install msodbcsql17 on AWS EC2 with CentOS/RedHat (Linux).

这些是我遵循的步骤，来自 Microsoft (LINK):

These are the steps, I have followed, from Microsoft (LINK):

sudo su

#Download appropriate package for the OS version
#Choose only ONE of the following, corresponding to your OS version

#RedHat Enterprise Server 6
curl https://packages.microsoft.com/config/rhel/6/prod.repo > /etc/yum.repos.d/mssql-release.repo

#RedHat Enterprise Server 7
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo

exit
sudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
sudo ACCEPT_EULA=Y yum install msodbcsql17
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y yum install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo yum install unixODBC-devel

该指令一直工作到安装 msodbcsql17 为止.我收到以下错误消息:

The instruction work until the installation of msodbcsql17. I get the following error message:

Error: Package: msodbcsql17 (packages-microsoft-com-prod)
           Requires: unixODBC >= 2.3.1
           Available: unixODBC-2.2.14-14.7.amzn1.i686 (amzn-main)
               unixODBC = 2.2.14-14.7.amzn1

我认为问题是，unixODBC 的最大可用版本小于 2.3.1，但是我如何安装 msodbcsql17，以便与 Microsoft 连接?

I think the problem is, that the maximum available version of unixODBC is less then 2.3.1, but how can I install msodbcsql17, to connect with Microsoft?

推荐答案

经过长时间的研究，我找到了一个解决方案:

After a long time of research, I have figured out a solution:

1. 从任何来源下载 unixODBC >= 2.3.1，作为 rpm (示例源)
2. 从 Microsoft 以 rpm 的形式下载 msodbcsql17 和 mssql-tool(Repo 链接)(在我的情况下，mssql-17-17.1.0.1-1.x86_64.rpm 和 mssql-tools-17.1.0.1-1.x86_64.rpm)
3. 通过 ftp(如 FileZilla)将文件传输到 EC2 实例
4. 使用 EC2 终端并转到上传文件的目录
5. 输入sudo rpm -i unixODBC-2.3.1-11.el7.x86_64.rpm 安装需要的版本(可能需要把版本号改成上传的版本号文件)
6. 输入sudo rpm -i msodbcsql17-17.1.0.1-1.x86_64.rpm

7. 输入sudo rpm -i mssql-tools-17.1.0.1-1.x86_64.rpm

1. Download the unixODBC >= 2.3.1 from any source, as rpm (Example source)
2. Download the msodbcsql17 and mssql-tool as rpm from Microsoft (Link to Repo) (msodbcsql17-17.1.0.1-1.x86_64.rpm and mssql-tools-17.1.0.1-1.x86_64.rpm in my case)
3. Transfer the files via ftp (like FileZilla) to the EC2 instance
4. Use EC2 terminal and go to the directory of the uploaded files
5. Enter sudo rpm -i unixODBC-2.3.1-11.el7.x86_64.rpm to install the necessary version (Perhaps, you have to change the version number to the version number of the uploaded file)
6. Enter sudo rpm -i msodbcsql17-17.1.0.1-1.x86_64.rpm

7. Enter sudo rpm -i mssql-tools-17.1.0.1-1.x86_64.rpm

按照 Microsoft 说明的其余部分，就像在您的问题中一样.

Follow the rest of the Microsoft instruction, like in your question.

除了rpm -i，你也可以使用yum install

更新:请看@KnudLarsen 的评论！

UPDATE: Please take a look at the comment from @KnudLarsen!

这篇关于在 Linux Redhat/CentOS 上为 msodbcsql17 安装 unixODBC >= 2.3.1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！