SSIS:错误->无法创建托管的连接管理器(VS 2010-AdoNet MySql) [英] SSIS: Error --> Could not create a managed connection manager (VS 2010 - AdoNet MySql)

问题描述

我刚刚升级了Visual Studio的Connector/C#，但出现了以上错误.一切似乎都很好，预览查询在程序包中也可以正常工作，但是在执行时会发生此错误.

I just upgraded my Connector/C# for Visual Studio and I get the error above. Everything seems fine, the preview queries work just fine in the package but upon execution this error occurs.

• 升级前一切正常
• 我删除了以前的连接管理器，并添加了一个全新的连接器
• 测试连接成功

过去有同样问题的人吗?关于32/64位操作系统的猜测很多，尽管MySQL官方网站指出，即使安装程序说的是x86，也没有任何意义.(注意:MySQL Installer是32位，但将同时安装32位和64位二进制文​​件.)

Anyone with the same problem in the past? There is a lot of speculation on 32/64 bit OSes, though MySQL official website states that even though the installer says x86, that means nothing (Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries.).

编辑->我尝试通过SSIS脚本手动连接，以查看编码异常是否提供了更多信息.不幸的是，它提供的甚至更少了

EDIT -> I tried connecting manually through an SSIS script to see if the coded exception provided more info. Unfortunatelly it provided even less

ConnectionManager connMan = Dts.Connections[7];
try
{
    connMan.AcquireConnection(Dts.Transaction);
}
catch (Exception ex)
{
    Dts.Events.FireError(-1, "Elt-Proc:", ex.Message, "", 0);
}

推荐答案

找到了答案:

问题在于VS-2010，SSIS和最新的ADO .Net连接器/MySQL for Visual Studio.

Problem was with VS-2010, SSIS, and latest ADO .Net connector / MySQL For Visual studio.

我已经安装了最新的Connector/Net 6.7.4和用于Visual Studio的MySQL.我注意到连接属性字符串中的版本为6.6.5.

I had installed the latest Connector/Net 6.7.4 and the MySQL for Visual Studio. I noticed that the version in the string at the connection properties was 6.6.5.

因此，我卸载了6.7.4版本，然后重新安装了6.6.5版本，并像一个超级按钮一样工作.

So I uninstalled the 6.7.4 version and re-installed the 6.6.5 version and worked like a charm.

我希望这也会对其他人有所帮助.我花了太多时间来找出答案.

I hope this will help others as well. It took way too much time for me to find out.

重要提示:如果SSIS服务器和VISUAL STUDIO DEV计算机具有不同的Connector/.Net版本，也会发生此错误(在服务器端)

IMPORTANT: This error will also occur (on the server side) if SSIS Server and VISUAL STUDIO DEV Computer have different Connector/.Net Versions

这篇关于SSIS:错误->无法创建托管的连接管理器(VS 2010-AdoNet MySql)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！