我正在尝试遵循指南此处展示了如何通过 ODBC 将 azure cosmos-db 链接为链接服务器。我已经创建了 x64 和 x86 版本的远程 cosmos-db 的 ODBC 链接。从 ODBC 管理控制台中检查时，这些连接似乎没有问题，我什至可以在设置架构时看到数据，但是我无法创建工作链接服务器，因为在测试连接时出现以下错误..
“ [microsoft][ODBC Driver Manager] 未找到数据源名称且未指定默认驱动程序”
我相信这可能是因为我安装了 SQL Express 并且“Providers”文件夹中缺少“Providers”文件夹>链接服务器”文件夹。因此，我假设我没有在本地运行的 SQL Server 实例上安装必要的提供程序。
我尝试安装 OLE DB 驱动程序 和 ODBC 驱动程序，但是这些没有帮助。
I'm attempting to follow the guide here which shows how to link an azure cosmos-db as a linked server via ODBC. I have created the ODBC links to the remote cosmos-db in both x64 and x86 flavours. These appear to connect without issue when checking from within the ODBC Admin console and I can even see the data when setting up a schema, however I am unable to create a working linked server as I get the following error when testing the connection ..
"[microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
I Believe this is maybe because I have SQL Express installed and the "Providers" folder is missing from the "Linked Server" folder. I am therefore assuming that I do not have the necessary providers installed on the SQL Server Instance running locally.
I have attempted to install both the OLE DB Driver and the ODBC Driver, however these have not helped.
发布评论