我使用 VB 编写了一个 Windows 服务,该服务从 Visual Foxpro 数据库中读取一些遗留数据以插入 SQL 2005。问题是这种用法在 Windows Server 2003 32 位中运行良好,但客户端最近转移到了 Windows 2003 64 位现在该服务将无法使用。我收到一条消息,指出未找到 VFP .NET OLEDb 提供程序。我研究过,一切似乎都指出没有解决方案。任何帮助,请...


您是否尝试过在高级编译器选项中将目标 CPU 更改为x86而不是?"Any CPU"我知道这OLEDB通过强制使用 32 位版本解决了其他提供商的一些问题。
您需要在目标CPU设置为的情况下进行编译,以强制您的代码x86使用. 32 bitVFP OLE Db provider Microsoft 已声明没有发布64-bitVisual FoxPro OLE Db 提供程序版本的计划。值得一提的是,微软还表示VFP 9 是最终版本Visual FoxPro,支持将以2015. 如果您需要 的OLE DB提供程序VFP 9,可以在此处获取。
Sybase Anywhere has a OLEDB provider for VFP tables. It states in the page that the server supports 64 bit Windows, don't know about the OLEDB provider: Support 64-bit Windows and Linux Servers In order to further enhance scalability, support for the x86_64 architecture was added to the Advantage Database Servers for Windows and Linux. On computers with an x86_64 processor and a 64 bit Operating System the Advantage Database Server will now be able to use memory in excess of 4GB. The extra memory will allow more users to access the server concurrently and increase the amount of information the server can cache when processing queries. I didn't try it by myself, but some people of the VFP newsgroups reports that it works OK. Link to the Advantage Server / VFP Page