mysql ODBC 连接器在stamps.com 数据源中不可用 [英] Mysql ODBC connector not available in stamps.com datasource
问题描述
今天，我们将stamps.com 软件升级到了17.5 版.此版本要求 ODBC 驱动程序为 64 位.我不认为这是一个问题.系统是64bit，下载了最新的MySQL ODBC 64Bit 8.0.22版本.ODBC 数据源管理器已加载，我可以访问它.我创建了数据源(经过测试)，但是当我尝试通过 Stamps.com 分配它时，出现错误...
Today, we upgraded stamps.com software to version 17.5. This build requires that ODBC drivers be 64bit. I didn't think that was a problem. System is 64bit, and downloaded the latest MySQL ODBC 64Bit version 8.0.22. ODBC Data Source Administrator loads up, and I can access it. I create the datas ource (tested) but when I try to assign it via Stamps.com I get the error...
"Unable to connect to the selected data source. Check if you need to add a Username and Password"
奇怪.同样，我可以通过 ODBC 数据源管理器测试连接.它选择适当的数据库等.驱动程序是 MySQL ODBC 8.0 ANSI 驱动程序(版本 8.00.22.00).
Odd. Again, I can test connection via ODBC Data Source Administrator. It selects the proper database, etc. The driver is MySQL ODBC 8.0 ANSI Driver (Version 8.00.22.00).
如果我尝试创建新数据源"通过 Stamps.com.单击其他/高级(SQL 等)"并单击添加"，我在任何选项中都看不到任何 MySQL 驱动程序.
If I try to "Create a new data source" via Stamps.com. Click 'Other/Advanced (SQL,etc)' and click 'Add', I do not see any MySQL drivers anywhere the options.
我已经多次完全卸载重新安装 8.0.22.
I've completely uninstalled re-installed 8.0.22 multiple times.
如果我不尝试通过 Stamps.com 创建新的 DSN，而是选择一个现有的 DSN，但单击配置".我收到以下错误.
If I don't try to create a new DSN through Stamps.com but rather select an existing one, but click 'configure'. I get the following errors.
"The setup routines for the MySQL ODBC 8.0 ANSI Driver ODBC driver could not be found. Please reinstall the driver."
关注..
"---------------------------
Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed
---------------------------
Errors Found:
The specified DSN contains an architecture mismatch between the Driver and Application"
所以看起来 MySQL ODBC 驱动程序仍然是 32 位的?我明明装的是64位的，系统是64位的，所以不确定.最初的 ODBC 驱动程序可能是一年前的 32 位，但就像我提到的，我已经通过卸载删除了那些 .dll.
So it seems like the MySQL ODBC driver is still 32 bit? I clearly installed 64 bit, and the system is 64 bit, so not sure. It's possible the original ODBC driver was 32 bit from a year ago, but like I mentioned, I have removed those .dll via uninstall.
我想知道我是否在寻找错误的 32 位应用程序.在 ODBC 数据源管理器下的关于选项卡中，
I'm wondering if I'm chasing the wrong 32 bit application. Under ODBC Data Source Administrator, in the About tab,
关于 ODBC 核心组件..
For About the ODBC core components..
Administrator C:Windowssystem32odbccp32.dll
Control Panel Startup C:Windowssystem32odbcad32.exe
Cursor Library C:Windowssystem32odbccr32.dll
Driver Manager C:Windowssystem32odbc32.dll
Localized Resource DLL C:Windowssystem32odbcint.dll
Unicode Cursor Library C:Windowssystem32odbccu32.dll
所以看起来 ODBC 的核心"是 32 位的?研究如何为 64 位更新这些.嗯...根据我最初的研究，那些 .dll/.exe 是 64 位的，因为它们在 system32 中而不是在 sysWOW64 中.似乎违反直觉?
So it looks like the 'core' for ODBC is 32 bit? Looking into how to update these for 64bit. Hmmm... based on my initial research, those .dll/.exe are 64bit since they're in system32 and not in sysWOW64. Seems counter intuitive?
有什么建议吗?
推荐答案
联系支持后，他们通知我 17.5 不支持 ODBC.所以不确定 - 为什么我需要升级到 64 位，以及为什么它声明我的 ODBC 驱动程序需要是 64 位，因为它不兼容.
After contacting support, they informed me that ODBC is not supported with 17.5. So not sure - why I needed to upgrade to 64bit, and why it states that my ODBC drivers need to be 64bit, since it's not compatible.
这是需要做的事情.下载邮票清理工具:https://support.stamps.com/outgoing/clean.exe
Here is what needs to be done. Download Stamps clean tool: https://support.stamps.com/outgoing/clean.exe
然后运行密钥工具以删除任何注册表值:https://support.stamps.com/outgoing/key.exe
Then run key tool to remove any registry values: https://support.stamps.com/outgoing/key.exe
那么最后需要安装17.4版本http://support.stamps.com/outgoing/stamps174.exe
Then finally, you need to install version 17.4 http://support.stamps.com/outgoing/stamps174.exe
回滚到 32 位 ODBC 驱动程序.
Roll back to the 32bit ODBC drivers.
在这次惨败之后，我们实施了更好的协议.基本上是运行 Stamps.com 的辅助机器，在推出到我们的主要生产机器之前，将在那里测试未来的更新.
After this fiasco, we've implemented better protocols. Basically secondary machine with Stamps.com running on it and will test future updates there before rolling out to our primary production machine.
这篇关于mysql ODBC 连接器在stamps.com 数据源中不可用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
