Re: Installing foxpro oledb on SQL 2005 64 bit

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hi John,

The 32-bit OLE DB data provider won't work on a 64-bit machine, other than
running in compatibility mode. Your SQL 2005 would need to be the 32-bit
edition, not the 64-bit edition.

To date there have not been any announcements about a 64-bit OLE DB data
provider for Visual FoxPro.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com


"jp" <jp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:631F54E9-0611-458C-9B35-8F86101A7367@xxxxxxxxxxxxxxxx
I have installed the 32 bit version of foxpro oledb (vfpoledb.dll) on SQL
2005 (64 bit) and it doesn't appear in the list of available providers
when I
try to create a linked server.

I see that it installed to the 32 bit "side" of the program files.

What do I need to do to get it installed properly on my SQL 2005?



.



Relevant Pages

  • Problem with Linked Server from SQL to DB2
    ... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
    (microsoft.public.data.oledb)
  • Problem with Linked Server from SQL to DB2
    ... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
    (microsoft.public.sqlserver.server)
  • Re: Supporting SQL Server and Oracle query syntax
    ... We have developed a framework called Mimer Provider Manager (Mpm). ... Instead of working directly towards a specific Data Provider, ... comes with plug-ins for ODBC, Sql Server, Oracle, Mimer SQL and OleDB. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Current System as Global Variable
    ... I have changed the OLE DB Provider and have tested on the SQL Server ... and then I clicked the parameters tab it ...
    (microsoft.public.sqlserver.dts)
  • Re: XP_CmdShell and OLE provider
    ... If I execute the below line in SQL Query Analyzer, ... I am not finding the one I installed: "Microsoft OLE DB Provider for Visual ...
    (borland.public.delphi.database.ado)