I am trying to export a the results of a SQL query into Excel. I found this YouTube video that shows how to achieve this (https://www.youtube.com/watch?v=xCyZNY0isUM).
我正在尝试将SQL查询的结果导出到Excel中。我找到了这个YouTube视频，展示了如何实现这一点(https://www.youtube.com/watch?v=xCyZNY0isUM)。
Following these instructions, I right click on my database, go to Tasks > Export. The wizard launches. I pass the initial page, and I get to the "Choose a data Source". I leave the default (.Net Framework Data Provider for Odbc) and click "Next". Here, I get this error message:
按照这些说明，我右键单击我的数据库，转到Tasks >导出。向导启动。我传递初始页面，然后到达“选择数据源”。我保留默认值(。Net Framework数据提供程序用于Odbc)并单击“Next”。这里，我得到了错误消息:
connection string property has not been initialized (System.Data).
连接字符串属性尚未初始化(System.Data)。
Thank you for your help.
谢谢你的帮助。
2 个解决方案
#1
3
Change the source from the default to "SQL Native Client" which relies on Windows Authentication.
将源从默认的“SQL本机客户端”更改为“SQL本机客户端”，该客户端依赖于Windows身份验证。
#2
0
Actually I had the same error but I changed the Choose Destination to native option (the last one) instead of doing "Choose Source" and apparently it worked.
实际上，我有相同的错误，但是我将选择目的地改为本地选项(最后一个)，而不是“选择源”，显然它是有效的。
#1
3
Change the source from the default to "SQL Native Client" which relies on Windows Authentication.
将源从默认的“SQL本机客户端”更改为“SQL本机客户端”，该客户端依赖于Windows身份验证。
#2
0
Actually I had the same error but I changed the Choose Destination to native option (the last one) instead of doing "Choose Source" and apparently it worked.
实际上，我有相同的错误，但是我将选择目的地改为本地选项(最后一个)，而不是“选择源”，显然它是有效的。