使用Azure Data Factory V2创建链接服务到内部部署MS Access数据库时遇到问题（预览）。 [英] Trouble creating linked service to on-premise MS Access database with Azure Data Factory V2 (Preview).

问题描述

我正在使用Azure Data Factory V2（预览版）并创建管道以将内部部署数据转移到Azure中。 我创建并安装了一个集成运行时（IR）自托管服务器，并成功将数据从内部部署的SQL Server数据库
移动到Azure Blob存储中。

I am using Azure Data Factory V2 (Preview) and creating pipelines to shift on-premise data into Azure.  I have created and installed an Integration Runtime (IR) self hosting fine and am successfully moving data out of an on-premise SQL Server database into Azure Blob Storage.

我需要现在为Microsoft Access数据库执行相同的方法，此安装/测试位于我的C：驱动器上。

I need to do the same approach now for a Microsoft Access Database, which for this setup/test is sitting on my C: drive.

按照此处的说明操作;

Following instructions here;

https://docs.microsoft.com/en-us/azure/data-factory/connector-odbc#microsoft-access-source

https://docs.microsoft.com/en-us/azure/data-factory/connector-odbc#microsoft-access-source

在Azure数据工厂UI工具中创建新的链接服务，我选择ODBC并通过现有的命名IR自托管运行时连接。

Creating a new linked service in the Azure Data Factory UI tool, I'm picking ODBC and connecting via the existing named IR self-hosted runtime.

对于连接字符串我'我正在尝试你常用的连接字符串。 例如;

For the connection string I'm trying the usual connection strings you'd use.  For example;

Provider = Microsoft.Jet.OLEDB.4.0;数据源= C：\Program Files \FolderA\FolderB \ MyDatabase.mdb;

我在文件名路径中尝试使用双反斜杠，但没有成功。

I'm trying double back slashes in the filename path too but no success.

无法连接到数据库。错误消息：错误[IM002] [Microsoft] [ODBC驱动程序管理器]未找到数据源名称且未指定默认驱动程序

在Data Factory UI中，我还尝试使用Advanced JSON Editor指定所有设置。 还在IR Config Manager预览工具中尝试了这些。

In the Data Factory UI I have also tried using the Advanced JSON Editor to specify all the settings.  Have also tried these in the IR Config Manager Preview tool.

{

推荐答案

这是一年，你有这个工作吗？我在同一条船上。我为我的连接字符串使用类似的JSON。 

It's been a year, have you gotten this to work? I'm in the same boat. I use the similar JSON for my Connection String. 

我甚至尝试在本地ODBC管理器中设置DSN并在ODBC链接服务中引用它。还尝试了IR工具的诊断选项卡。我每次都收到相同的错误消息： 

I even tried setting up a DSN in my local ODBC Administrator and referencing that in an ODBC Linked Service. Also tried the IR Tool's Diagnostics tab. I get the same error message every time: 

错误[HY000] [Microsoft] [ODBC Microsoft Access驱动程序] Microsoft Access数据库引擎无法打开或写入文件'（未知）'。它已由其他用户独占打开，或者您需要获得查看和写入其数据的权限。

我不明白。我指定文件位置（是的，需要双反斜杠来逃避JSON）;任何其他进程或用户都不会打开该文件;没有设置密码。

I don't get it. I specify the file location (yes, double backslashes are needed to escape the JSON); the file is NOT open by any other process or user; there is no password set on it.

非常感谢任何帮助或建议。

Any help or advice would be greatly appreciated.

问候，

这篇关于使用Azure Data Factory V2创建链接服务到内部部署MS Access数据库时遇到问题（预览）。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！