blocks|key|976281|text|这里的问题是，“一些关键的CLI工具(如nvm和brew+)没有为新的M1体系结构构建本机版本。”来源。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|976282|幸运的是，Apple附带了一个名为Rosetta+2的翻译层，它基本上是一个CLI接口，您必须通过它安装像brew这样的工具才能正确安装。|976283|在这个中型员额中，您可以了解如何使用Rosetta+2。我们通过安装Python3.9、pip、with、openssl、unixodbc、freetds、正确的驱动程序以及最后的pyodbc+(按这个顺序)使用Rosetta+2实现了pyodbc的工作。|976284|entityMap|0|LINK|mutability|MUTABLE|url|https://www.courier.com/blog/tips-and-tricks-to-setup-your-apple-m1-for-development/|1|https://medium.com/swlh/run-x86-terminal-apps-like-homebrew-on-your-new-m1-mac-73bdc9b0f343^0|K|3|O|4|1D|2|0|0|1H|4|0|1|6|1|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|C]]|D|@$9|Y|A|Z|1|10]]|E|$]]|$1|F|3|G|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|14|8|@]|D|@$9|15|A|16|1|17]]|E|$]]|$1|J|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]|R|$5|M|N|O|E|$P|S]]]]

The problem here is that &quot;several critical CLI tools like <code>nvm</code> and <code>brew</code> do not have native versions built for the new M1 architecture.&quot; <a href="https://www.courier.com/blog/tips-and-tricks-to-setup-your-apple-m1-for-development/" rel="nofollow noreferrer">Source</a>.
Luckily Apple Silicon comes with a translation layer named Rosetta 2, which is basically a CLI interface through which you have to install tools like <code>brew</code> in order for them to install correctly.
In <a href="https://medium.com/swlh/run-x86-terminal-apps-like-homebrew-on-your-new-m1-mac-73bdc9b0f343" rel="nofollow noreferrer">this Medium post</a> you can read how to use Rosetta 2. We got pyodbc working by installing Python 3.9, pip, wheel, openssl, unixodbc, freetds, the correct drivers and finally pyodbc (in this order) all with Rosetta 2.

blocks|key|976311|text|首先，按照微软这里的指示安装ODBC驱动程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|976312|此外，Microsoft建议创建以下符号链接：|976313|sudo+ln+-s+/usr/local/etc/odbcinst.ini+/etc/odbcinst.ini
sudo+ln+-s+/usr/local/etc/odbc.ini+/etc/odbc.ini|code-block|syntax|javascript|976314|但是，这些文件在M1+macs上的位置可能会有所不同，这取决于默认的homebrew目录。在我的例子中，下列途径起作用：|976315|sudo+ln+-s+/opt/homebrew/etc/odbcinst.ini+/etc/odbcinst.ini
sudo+ln+-s+/opt/homebrew/etc/odbc.ini+/etc/odbc.ini|976316|entityMap|0|LINK|mutability|MUTABLE|url|https://learn.microsoft.com/th-th/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-2017^0|7|2|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|C|$]]|$1|M|3|N|5|H|7|13|8|@]|9|@]|C|$I|J]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

First, install the ODBC driver as instructed by Microsoft <a href="https://learn.microsoft.com/th-th/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-2017" rel="nofollow noreferrer">here</a>.
Further, Microsoft recommends creating symbolic links as follows:
<pre><code>sudo ln -s /usr/local/etc/odbcinst.ini /etc/odbcinst.ini
sudo ln -s /usr/local/etc/odbc.ini /etc/odbc.ini
</code></pre>
However, the location of those files on M1 macs might be different, depending on the the default homebrew directory. In my case, the following paths worked:
<pre><code>sudo ln -s /opt/homebrew/etc/odbcinst.ini /etc/odbcinst.ini
sudo ln -s /opt/homebrew/etc/odbc.ini /etc/odbc.ini
</code></pre>

blocks|key|961560|text|找到以下链接有助于在MacBook+M1芯片上安装pyodbc。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|961561|我们碰巧得到sql.h文件丢失错误，如果我们试图安装车轮直接从网站，它抛出平台，不支持错误。|961562|遵循下面的文档，然后将导出命令添加到您的zrc或bash文件中，您应该会做得很好。|961563|https://whodeenie.medium.com/installing-pyodbc-and-unixodbc-for-apple-silicon-8e238ed7f216|offset|length|961564|需要更多关于bug的阅读，以及人们是如何尝试学习它的。|961565|https://github.com/mkleehammer/pyodbc/issues/846|961566|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|0|0|2I|0|0|0|0|1C|1|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@$H|Z|I|10|1|11]]|A|$]]|$1|J|3|K|5|6|7|12|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|13|8|@]|9|@$H|14|I|15|1|16]]|A|$]]|$1|N|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|G]]|U|$5|Q|R|S|A|$T|M]]]]

Found the following link helpful to install pyodbc on MacBook M1 Chip.
We happen to get sql.h file missing error and if we try to install the wheel directly from the site it throws platform not supported error.
Follow the below document and then add the export commands into your zrc or bash file and you should be good to go.
<a href="https://whodeenie.medium.com/installing-pyodbc-and-unixodbc-for-apple-silicon-8e238ed7f216" rel="nofollow noreferrer">https://whodeenie.medium.com/installing-pyodbc-and-unixodbc-for-apple-silicon-8e238ed7f216</a>
Need more reading about the bug and how people tried to learn it.
<a href="https://github.com/mkleehammer/pyodbc/issues/846" rel="nofollow noreferrer">https://github.com/mkleehammer/pyodbc/issues/846</a>

blocks|key|976342|text|在macOS+Ventura上使用2022年MacBook+Pro的默认Homebre&odbc安装仍然存在这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|976343|唯一起作用的是完全卸载Homebrew和ODBC驱动程序，然后用前缀arch+-x86_64重新安装这两个驱动程序。|offset|length|style|CODE|976344|$+arch+-x86_64+/bin/bash+-c+"$(curl+-fsSL+https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"|976345|$+arch+-x86_64+brew+install+msodbcsql18+mssql-tools18|976346|entityMap^0|0|Y|C|0|0|32|0|0|1H|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|M|$]]

I still had this issue with the default Homebrew &amp; ODBC installations on macOS Ventura with a 2022 MacBook Pro.
The only thing that worked was to completely uninstall Homebrew and the ODBC drivers and then reinstall both with the prefix <code>arch -x86_64</code>.
<code>$ arch -x86_64 /bin/bash -c &quot;$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)&quot;</code>
<code>$ arch -x86_64 brew install msodbcsql18 mssql-tools18</code>

blocks|key|961699|text|这就是我在m2+macbook上工作的地方(来自正式的ms文档)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|961700|确保你已经安装了自制软件。|961701|/bin/bash+-c+"$(curl+-fsSL+https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"
brew+tap+microsoft/mssql-release+https://github.com/Microsoft/homebrew-mssql-release
brew+update
HOMEBREW_ACCEPT_EULA=Y+brew+install+msodbcsql17+mssql-tools

sudo+ln+-s+/opt/homebrew/etc/odbcinst.ini+/etc/odbcinst.ini
sudo+ln+-s+/opt/homebrew/etc/odbc.ini+/etc/odbc.ini|code-block|syntax|javascript|961702|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This is what worked for me on a m2 macbook (from the official ms documentation). 
Make sure you have homebrew installed.
<pre><code>/bin/bash -c &quot;$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)&quot;
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
HOMEBREW_ACCEPT_EULA=Y brew install msodbcsql17 mssql-tools

sudo ln -s /opt/homebrew/etc/odbcinst.ini /etc/odbcinst.ini
sudo ln -s /opt/homebrew/etc/odbc.ini /etc/odbc.ini
</code></pre>

I have a new M1 pro macbook and I'm trying to install pyodbc and relevant drivers on my machine.
So far I have installed unixodbc via homebrew and ODBC drivers according to the instructions found here: <a href="https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver15https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver15" rel="nofollow noreferrer">https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver15https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver15</a>
I then pip installed pyodbc but when I try to run <code>pyodbc.connect()</code> within a test script, python just aborts with the following message, regardless which connection string I use:
<code>[1] 2086 abort python test.py</code>
After investigating a bit more I find that pyodbc doesn't have any drivers. When I run <code>pyodbc.drivers()</code> I get an empty list. So it seems like pyodbc cannot find the drivers I installed earlier.
Here is the output when I run <code>odbcinst -j</code>:
<pre><code>unixODBC 2.3.9
DRIVERS............: /opt/homebrew/etc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.ini
FILE DATA SOURCES..: /opt/homebrew/etc/ODBCDataSources
USER DATA SOURCES..: /Users/kdot/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
</code></pre>
and the <code>odbcinst.ini</code> file contains:
<pre><code>[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/homebrew/lib/libmsodbcsql.17.dylib
UsageCount=3
</code></pre>
I've also tried to explicitly give the driver file path to pyodbc in the connection string but then <code>pyodbc.connect()</code> just hangs instead of aborting right away.
I am running all of this within a virtual environment with the following versions:
<pre><code>python: 3.8.10
pyodbc: 4.0.32
</code></pre>
Does anyone know how to make pyodbc see and use the relevant drivers?

How to properly install pyodbc and drivers on M1 mac

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我有一个新的M1专业macbook，我正试图在我的机器上安装pyodbc和相关驱动程序。到目前为止，我已经通过自制和ODBC驱动程序安装了unixodbc，按照下面的说明：然后我安装了pyodbc，但是当我试图在测试脚本中运行pyodbc.connect()时，python只会使用以下消息中止，而不管我使用的是哪个连接...

问如何在M1 mac上正确安装pyodbc和驱动程序
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在M1 mac上正确安装pyodbc和驱动程序EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在M1 mac上正确安装pyodbc和驱动程序
EN