locked
Query Visual FoxPro .dbf files from SQL Server 2005 (64-bit) RRS feed

  • Question

  • I need to query a foxpro database from a new SQL Server 2005 (64-bit) instance Running on a 64-bit Windows 2003 Server.  I can't find an ODBC driver, only the OLE DB one.
    I install the OLE DB and it creates the appropriate registry settings, but it doesn't show up.
    Please help, I'm probably not on the right track, but I don't know where to go from here.
    Any and all attempts at helping are greatly appreciated.
    Thanks,
    jim
    Thursday, April 27, 2006 4:39 PM

Answers

  • Hi Jim,

    Technology is always difficult when you're playing on both sides of a fence. An example of this is the move from Visual Studio 6 to VS 7+ and the .NET framework. Although there are converters, all but the simplest code won't run as-is on VS.NET. By the way, FoxPro went through a similar upgrade between versions 2.x and 3.

    I'm not much of a server person but I don't see 64-bit SQL as handicapped since I consider it to be the OLE DB data providers' "responsibility" to be compatible with the 64-bit SQL Server software. 

    In these days when 64-bit machines are still not all that prevalent one should assume that the "Windows Server 2003" listed on the OLE DB downloads page would refer to the 32-bit version only and that if the 64-bit version were supported then "64" would be specifically mentioned.

    How would you compile 64-bit SQL Server as a 32-bit application? Well, since you don't have the source you can't. What you would need to do is install the 32-bit version, as you suggested.

    Visual Studio .NET is Microsoft's flagship development platform; FoxPro isn't for either data or development. The resources devoted to it at Microsoft are in keeping with it's value to the company.  

    Monday, May 1, 2006 9:34 PM

All replies

  • Hi Jim,

    The latest (and last) VFP ODBC driver is downloadable from http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc and the latest OLE DB data provider is downloadable from http://msdn.microsoft.com/vfoxpro/downloads/updates.

    However, the OLE DB data provider isn't compatible with a 64-bit OS (and I assume the ODBC driver isn't either though you can check) which is why it doesn't show up in your list.

    Thursday, April 27, 2006 8:11 PM
  • The ODBC driver is 32 bit. The OLE DB provider is supposed to be 64-bit compatible, it installed and I can see the registry entries, but I can't seem to figure out how to use it.

    Is it not possible to query .dbf files from SQL Server 2005 64-bit? 

    I know I'm not the only person trying to query a Microsoft Visual FoxPro database from a 64-bit SQL server, am I? 

    Thursday, April 27, 2006 8:59 PM
  • Hi Jim,

    What makes you think that the OLE DB data provider is 64-bit compatible? The following was posted elsewhere by Lee Mitchell. Although he speaks to the case of a Visual Studio app being compiled as 64-bit I assume the same goes for the 64-bit version of SQL Server:

    The 64-bit application will not see a 32 bit OLE DB Provider.  You need to compile the application as a 32-bit app, and it can then use the 32-bit OLE DB Provider.

    There is no 64-bit VFP OLE DB Provider at this time. ......


    I hope this helps.


    This posting is provided "AS IS" with no warranties, and confers no rights.


    Sincerely,
    Microsoft FoxPro Technical Support
    Lee Mitchell


     

    Thursday, April 27, 2006 10:02 PM
  • Cindy, I  appreciate the information you provided, although I can't seem to understand why Microsoft would roll out a product that is handicapped the way the 64-bit SQL Server is. 

    I assumed that since it created the correct registry keys, that the OLE DB provider was 64 bit.  I'm running Windows 2003 Server, which is one of the OS's listed on the download page.

    So, I should compile SQL Server as a 32 bit application?  If so, how do I do this? 

    I also assumed that Microsoft would make it possible to query one Microsoft product from another.  Is Microsoft no longer supporting Visual FoxPro nor SQL server, new versions have recently been released for both?  What gives?

    Is 64 bit computing with  Microsoft not an actuality?

    I guess I'll just have to call stored procedures on a 32 bit SQL Server 2000 from the SQL Server 2005 64-bit box.  I'll tell ya, this is a great way to start out with a new product, it really gives me great confidence in this product handling my companies most critical data!    :(    ...NOT

    Microsoft: "We have a great new product, a 64 bit SQL Server!"

    Jim: "What drivers exist for it to connect to other databases?"

    Microsoft: "Well, you can connect to another SQL Server, Access, and...and, you can connect to Oracle."

    Jim: "What about FoxPro?"

    Microsoft: "Duh....we can't do that.  You'll have to buy another SQL Server, a 32-bit version and call stored procedures on that instance from you 64 bit SQL Server."

     

    Friday, April 28, 2006 4:00 PM
  • Hi Jim,

    Technology is always difficult when you're playing on both sides of a fence. An example of this is the move from Visual Studio 6 to VS 7+ and the .NET framework. Although there are converters, all but the simplest code won't run as-is on VS.NET. By the way, FoxPro went through a similar upgrade between versions 2.x and 3.

    I'm not much of a server person but I don't see 64-bit SQL as handicapped since I consider it to be the OLE DB data providers' "responsibility" to be compatible with the 64-bit SQL Server software. 

    In these days when 64-bit machines are still not all that prevalent one should assume that the "Windows Server 2003" listed on the OLE DB downloads page would refer to the 32-bit version only and that if the 64-bit version were supported then "64" would be specifically mentioned.

    How would you compile 64-bit SQL Server as a 32-bit application? Well, since you don't have the source you can't. What you would need to do is install the 32-bit version, as you suggested.

    Visual Studio .NET is Microsoft's flagship development platform; FoxPro isn't for either data or development. The resources devoted to it at Microsoft are in keeping with it's value to the company.  

    Monday, May 1, 2006 9:34 PM


  • >>Visual Studio .NET is Microsoft's flagship development platform; FoxPro isn't for either data or development.

    >>The resources devoted to it at Microsoft are in keeping with it's value to the company. 



    I also need to read a dbf file from 64 bit sql server.  Is Cindy's recommendation (above) that we seek software vendors other than microsoft still valid?  Thanks Cindy.


    Tuesday, July 15, 2008 11:07 PM