在 Linux Redhat/CentOS for 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:
- 从任何来源下载 unixODBC >= 2.3.1,作为 rpm (示例源码)
- 从 Microsoft 以 rpm 格式下载 msodbcsql17 和 mssql-tool(链接到 Repo)(msodbcsql17-17.1.0.1-1.x86_64.rpm 和 mssql-tools-17.1.0.1-1.x86_64.rpm 在我的例子中)
- 通过 ftp(如 FileZilla)将文件传输到 EC2 实例
- 使用EC2终端,进入上传文件所在目录
- 输入
sudo rpm -i unixODBC-2.3.1-11.el7.x86_64.rpm
安装需要的版本(或许你得把版本号改成上传的版本号文件) - 输入
sudo rpm -i msodbcsql17-17.1.0.1-1.x86_64.rpm
输入
sudo rpm -i mssql-tools-17.1.0.1-1.x86_64.rpm
- Download the unixODBC >= 2.3.1 from any source, as rpm (Example source)
- 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)
- Transfer the files via ftp (like FileZilla) to the EC2 instance
- Use EC2 terminal and go to the directory of the uploaded files
- 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) - Enter
sudo rpm -i msodbcsql17-17.1.0.1-1.x86_64.rpm
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 for msodbcsql17 上安装 unixODBC >= 2.3.1的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!