SQL Programming
Microsoft OLE DB Provider for Visual FoxPro not available (after saying it was available)
Gravatar is a globally recognized avatar based on your email address. Microsoft OLE DB Provider for Visual FoxPro not available (after saying it was available)
  Alejandro A Sosa
  All
  Aug 4, 2019 @ 07:08pm

While trying to import dbf tables to sql server using the Tasks > Import data > Microsoft OLE DB Provider for Visual FoxPro, and clicking Next I got this message:

TITLE: SQL Server Import and Export Wizard
The operation could not be completed.
Feature is not available. (Microsoft OLE DB Provider for Visual FoxPro)

I'm using SQL Server 14.0.2027.2 and SQL Server Management Studio v17.9.1

I did install Microsoft OLE DB Provider, and in fact the Management Studio just presented it as an option. Others have asked the same question in internet but I haven't found an answer. Perhaps it requires a 32 bit version of SQL Server?

Thank you very much.

Alex

Gravatar is a globally recognized avatar based on your email address. re: Microsoft OLE DB Provider for Visual FoxPro not available (after saying it was available)
  Jeff L
  Alejandro A Sosa
  Aug 5, 2019 @ 08:57am

Right, your SQL is probably 64 bit and the VFP OLE DB is 32 bit. I would not recommend dropping your SQL down to 32 bit.

There are other tools that can move the data from FoxPro to SQL or other DBs.

I like https://www.easyfrom.net/ ESF Database Migration Toolkit. You can create and save migration jobs and do staging and testing before you send the final data to your Production database.

It's expensive at $322 USD.

There are other tools, too. And worse, you could write something yourself in VFP using a SQL ODBC driver. The question is which SQL ODBC driver. Some support newer data types like Date, like Varchar(MAX), SmallDate, DateTime2, etc. It's a bit of a mess to find and figure out which driver will work for your data.

Start this process with determining your SQL Datatypes and find the appropriate SQL ODBC driver. It's going to be a compromise choice. Or you can use Chen's magic VFP Advanced. I think he addresses/fixes some of the ODBC problems.

Good luck!

Gravatar is a globally recognized avatar based on your email address. re: Microsoft OLE DB Provider for Visual FoxPro not available (after saying it was available)
  Alejandro A Sosa
  Jeff L
  Aug 5, 2019 @ 10:18am

Thank you for the comments Jeff. Appreciate them.

Alex

Gravatar is a globally recognized avatar based on your email address. re: Microsoft OLE DB Provider for Visual FoxPro not available (after saying it was available)
  Jeff L
  Alejandro A Sosa
  Aug 5, 2019 @ 10:26am

You're welcome.

I'm just sorry that I don't have the full story on which SQL ODBC drivers support which SQL datatypes. I've researched it before and have written about it, too.

Maybe I'll give myself something to do and work something up.

Gravatar is a globally recognized avatar based on your email address. re: Microsoft OLE DB Provider for Visual FoxPro not available (after saying it was available)
  Rick Strahl
  Jeff L
  Aug 6, 2019 @ 07:40am

If you do, a good place to put this is on the FoxPro Wiki - either directly or as a link to a white paper or blog post etc.

I've run into this many times myself and I also can't remember the details exactly as to what works and what doesn't with specific drivers.

+++ Rick ---

© 1996-2019