Excel ODBC连接问题和HY000 Curlerror
我正在尝试将Excel连接到我们的雪花实例，以便用户可以将数据拉入雪花。我已经安装了最新的ODBC驱动程序，并根据需要设置用户和服务器。身份验证器设置为外部浏览器。当我们尝试在Excel中使用该连接时，会发生两件事之一：
一堆浏览器选项卡打开，但用户能够连接并带来数据。不确定为什么我们有多个标签，但至少他们得到了他们需要的东西。
连接只是旋转，最终我们最终出现了一个HY000错误，说我们的URL的其余要求失败了；代码= 52 msg =服务器什么都没有返回（没有标题，没有数据），OS代码= 2，OSMSG ='否此类文件或目录'。
我们尝试了多个选项，并且我们所有其他连接（例如JDBC）在外部浏览器设置方面工作正常。可以连接的用户与无法连接的用户之间似乎没有太大区别。
I am trying to connect Excel to our Snowflake instance so that users can pull data into Snowflake. I've installed the latest ODBC driver and set the User and Server as required. The authenticator is set to externalbrowser. When we attempt to use that connection within Excel, one of two things occurs:
A bunch of browser tabs open but the user is able to connect and bring in data. Not sure why we have multiple tabs but at least they get what they need.
The connection just spins, and ultimately we end up with a HY000 error saying that the REST Request for our URL failed; code=52 msg=Server returned nothing (no headers, no data), oS code=2, osMsg='No such file or directory'.
We have tried multiple options and all of our other connections (JDBC for example) works just fine with the external browser setting. There doesn't seem to be much of a difference between users that can connect and those that can't.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
有一篇良好的知识库文章，内容涉及Excel与Snowflake连接。
跳过步骤1：如果您不使用SSO，则使用Azure AD配置SSO。继续步骤2。
这是文章： https://community.snowflake.com/s/article/how-to-connect-to-snowflake-authenticating-with-azure-azure-ad-sso-from-ms-ms-excel-excel-odbc-driver
There is a good Knowledge Base article written about connecting to Snowflake from Excel.
Skip Step 1: Configure SSO with Azure AD if you are not using SSO. Go on to Step 2 onward.
This is the article: https://community.snowflake.com/s/article/HOW-TO-connect-to-Snowflake-authenticating-with-Azure-AD-SSO-from-MS-Excel-ODBC-driver