<p>I wrote a windows service using VB that read some legacy data from Visual Foxpro Databases to be inserted in SQL 2005. The problem is this use to run fine in Windows server 2003 32-Bits, but the client recently moved to Windows 2003 64-Bits and now the service won't work. I'm getting a message the the VFP .NET OLEdb provider is not found. I researched and everything seems to point out that there is no solution. Any Help, please...</p>

[{'answer_id': 799, 'author': 'Paul G', 'author_id': 162, 'author_profile': 'https://Stackoverflow.com/users/162', 'pm_score': 5, 'selected': True, 'text': '<p>Have you tried changing the target CPU to <code>x86</code> instead of <code>"Any CPU"</code> in the advanced compiler options? I know that this solves some problems with other <code>OLEDB</code> providers by forcing the use of the 32-bit version.</p>\n'}, {'answer_id': 877, 'author': 'Chris Miller', 'author_id': 206, 'author_profile': 'https://Stackoverflow.com/users/206', 'pm_score': 3, 'selected': False, 'text': '<p>You\'ll need to compile with the target <code>CPU</code> set to <code>x86</code> to force your code to use the <code>32 bit</code> version of the <code>VFP OLE Db provider</code>.  </p>\n\n<p><a href="http://msdn.microsoft.com/en-us/vfoxpro/bb190293.aspx" rel="noreferrer">Microsoft has stated</a> that there are no plans on releasing a <code>64-bit</code> edition of the Visual FoxPro OLE Db provider.  For what\'s worth, Microsoft has <a href="http://msdn.microsoft.com/en-us/vfoxpro/bb308952.aspx" rel="noreferrer">also stated</a> that VFP 9 is the final version of <code>Visual FoxPro</code> and support will end in <code>2015</code>.  If you need the <code>OLE DB</code> provider for <code>VFP 9</code>, you can get it <a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&amp;displaylang=en" rel="noreferrer">here</a>.</p>\n'}, {'answer_id': 4074, 'author': 'PabloG', 'author_id': 394, 'author_profile': 'https://Stackoverflow.com/users/394', 'pm_score': 1, 'selected': False, 'text': '<p><code>Sybase Anywhere</code> has a <code>OLEDB provider</code> for <code>VFP</code> tables. It states in the page that the server supports <code>64 bit Windows</code>, don\'t know about the <code>OLEDB provider</code>:</p>\n<blockquote>\n<p>Support 64-bit Windows and Linux Servers</p>\n<p>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.</p>\n</blockquote>\n<p>I didn\'t try it by myself, but <a href="http://weblogs.foxite.com/andykramek/archive/2008/01/05/5530.aspx" rel="nofollow noreferrer">some people</a> of the VFP newsgroups reports that it works OK.<p>\n<a href="http://devzone.advantagedatabase.com/dz/webhelp/Advantage9.0/Advantage.htm" rel="nofollow noreferrer">Link to the Advantage Server / VFP Page</a></p>\n'}]
['https://Stackoverflow.com/questions/717', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/-1/']