使用嵌入式Microsoft Query在Excel Mac 2016 ODBC连接中存储密码 [英] Storing password in Excel Mac 2016 ODBC connections using embedded Microsoft Query

问题描述

我正在建立一个Excel Mac 2016文件，该文件使用通过嵌入式Microsoft Query服务到SQL Server的多个连接.问题是我无法在连接中存储密码:每次打开文件时，Excel都会要求每个连接的密码，尽管它始终是相同的(现在我有8个连接).没有显示用于存储密码的复选框或选项.

I'm bulding an Excel Mac 2016 file that uses several connections to SQL Server using the embedded Microsoft Query service. The problem is that I'm unable to store the password in the connection: every time I open the file Excel asks for the password of every connection although it is always the same (and now I have 8 connections). No checkbox or option is displayed to store the password.

我检查了菜单中的每个选项，但无法找到此功能.另外，我尝试编辑连接字符串并添加; PWD ="或; Password ="，但是没有运气.在我看来，登录数据和查询应该分开，但不要分开.

I've checked every option in the menus but I've been unable to find this feature. Also, I've tried to edit the connection string and adding ";PWD=" or ";Password=" but no luck. It seems to me that the login data and the queries should be separated but they are not.

Mac和Windows版本的Excel之间似乎存在差异.也许这对于Mac是不可能的.类似的帖子提到了使用受信任的连接"选项，但在Mac上看不到.

It seems there are differences between the Mac and Windows version of Excel. Maybe this is not possible with Mac. A similar post refers to a "Use Trusted Connection" option but I can't see this on Mac.

Excel-Microsoft Query-SQL Server登录-使用受信任的连接"默认设置

谢谢大家.

推荐答案

它不会让我添加评论，所以我将添加一个答案.我在Windows中拥有Excel 2016，并且在连接字符串下方有一个保存密码复选框.我已经使用嵌入式服务完成了几个Microsoft查询，并且还建立了与系统DSN的连接.对我来说，奇怪的是，仅仅因为您在Mac上，您就错过了这个简单的复选框.如果您具有复选框，请单击它，然后保存文件.下次打开它时，它不再需要您输入密码.抱歉，这是完全没有用的. :-/

It won't let me add a comment, so I'm going to add an answer. I have Excel 2016 in Windows and there is a save password checkbox just below the connection string. I have done several microsoft queries with the embedded service and I've also setup a connection with system DSNs. Strange to me that you're missing that simple checkbox just because you're on Mac. If you have the checkbox, click it and then save the file. The next time you open it, it shouldn't ask for your password again. Sorry if this is completely useless. :-/

这篇关于使用嵌入式Microsoft Query在Excel Mac 2016 ODBC连接中存储密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！