Ошибка поставщик vfpoledb 1 не зарегистрирован на локальном компьютере

Alright, so I’ve got a Windows service that has a FileSystemWatcher that watches an output folder for some Visual FoxPro database files. And it leverages the VFPOLEDB.1 provider to read those files. I cannot go away from this provider because it’s being used in production.

However, I’ve never had to support this application before so that’s why my development box isn’t setup for it. Here is my environment:

• Windows 7 x64
• Visual Studio 2005
• .NET 2.0 Windows service

so, when I first started getting the error I figured I just didn’t have the provider at all, and I was right. So, I downloaded and installed it from here.

I then proceeded to drop the files in the folder again, but I got the same error.

I figured because it’s an x64 machine I might be experiencing problems with it getting registered since it was probably dropped into SysWOW64, and it was as I expected, so I ran this command:

regsvr32 "C:WindowsSysWOW64mscomct2.ocx"

and it said it was successfully registered (which means about nothing LOL) but I dropped the files in again — same error.

I have not yet rebooted my machine, and I can if somebody has a compelling reason that’s the problem, but generally speaking if the assembly is registered properly with regsvr32 that’s not necessary. I’ve worked with a ton of COM objects and never have to reboot to get to the object as long as I’ve registered it.

Does anybody know another step I need to perform to get this thing registered?

Alright, so I’ve got a Windows service that has a FileSystemWatcher that watches an output folder for some Visual FoxPro database files. And it leverages the VFPOLEDB.1 provider to read those files. I cannot go away from this provider because it’s being used in production.

However, I’ve never had to support this application before so that’s why my development box isn’t setup for it. Here is my environment:

• Windows 7 x64
• Visual Studio 2005
• .NET 2.0 Windows service

so, when I first started getting the error I figured I just didn’t have the provider at all, and I was right. So, I downloaded and installed it from here.

I then proceeded to drop the files in the folder again, but I got the same error.

I figured because it’s an x64 machine I might be experiencing problems with it getting registered since it was probably dropped into SysWOW64, and it was as I expected, so I ran this command:

regsvr32 "C:WindowsSysWOW64mscomct2.ocx"

and it said it was successfully registered (which means about nothing LOL) but I dropped the files in again — same error.

I have not yet rebooted my machine, and I can if somebody has a compelling reason that’s the problem, but generally speaking if the assembly is registered properly with regsvr32 that’s not necessary. I’ve worked with a ton of COM objects and never have to reboot to get to the object as long as I’ve registered it.

Does anybody know another step I need to perform to get this thing registered?

Can you please test this code (provided you have or created c:temp):

void Main()
{
    if (IntPtr.Size == 8)
    {
        Console.WriteLine("Sorry this is not going to work in 64 bits");
    }
    else
    {
        DataTable tbl=new DataTable();
        using (OleDbConnection con = new OleDbConnection(@"Provider=VFPOLEDB;Data Source=c:Temp"))
        {
            con.Open();
            new OleDbCommand("create table myTest (id int, dummy c(10))",con).ExecuteNonQuery();
            var cmd = new OleDbCommand(@"insert into myTest (id, dummy) values (?,?)",con);
            cmd.Parameters.Add("id", OleDbType.Integer);
            cmd.Parameters.Add("dum", OleDbType.VarChar,10);

            for (int i = 0; i < 10; i++)
            {
                cmd.Parameters["id"].Value = i + 1;
                cmd.Parameters["dum"].Value = $"Dummy#{i+1}";
                cmd.ExecuteNonQuery();
            }

            tbl.Load(new OleDbCommand("select * from myTest",con).ExecuteReader());
        }
        foreach (DataRow row in tbl.Rows)
        {
            Console.WriteLine($"{(int)row["id"]} : {(string)row["Dummy"]}");
        }
    }
    Console.ReadLine();
}

Or if you edit in Notepad and compile with csc:

using System;
using System.Data;
using System.Data.OleDb;
namespace Test
{
  class Test
  {

static void Main()
{
    if (IntPtr.Size == 8)
    {
        Console.WriteLine("Sorry this is not going to work in 64 bits");
    }
    else
    {
        DataTable tbl=new DataTable();
        using (OleDbConnection con = new OleDbConnection(@"Provider=VFPOLEDB;Data Source=c:Temp"))
        {
            con.Open();
            new OleDbCommand("create table myTest (id int, dummy c(10))",con).ExecuteNonQuery();
            var cmd = new OleDbCommand(@"insert into myTest (id, dummy) values (?,?)",con);
            cmd.Parameters.Add("id", OleDbType.Integer);
            cmd.Parameters.Add("dum", OleDbType.VarChar,10);

            for (int i = 0; i < 10; i++)
            {
                cmd.Parameters["id"].Value = i + 1;
                cmd.Parameters["dum"].Value = $"Dummy#{i+1}";
                cmd.ExecuteNonQuery();
            }

            tbl.Load(new OleDbCommand("select * from myTest",con).ExecuteReader());
        }
        foreach (DataRow row in tbl.Rows)
        {
            Console.WriteLine($"{(int)row["id"]} : {(string)row["Dummy"]}");
        }
    }
    Console.ReadLine();
}

}
}

Save it, say VFPOLEDBTest.cs and compile with:

csc VFPOLEDBTest.cs /platform:x86

and run:

VFPOLEDBTest.exe

Output:

d:Academy>VFPOLEDBTest.exe
1 : Dummy#1
2 : Dummy#2
3 : Dummy#3
4 : Dummy#4
5 : Dummy#5
6 : Dummy#6
7 : Dummy#7
8 : Dummy#8
9 : Dummy#9
10 : Dummy#10

RE: The ‘vfpoledb.1’ provider is not registered on the the local machine .. 64 bit FoxPro OLEDB connection ??

My client is 32 bit, my SSRS server is 64bit windows 2003 sp2

my connection string:

Provider=vfpoledb.1;Data Source=»someserrverdatag10.dbc»;Collating Sequence=machine

Report runs fine on my client from VS 2005.

I deploy and get this error when I run the report from reportserver

The ‘vfpoledb.1’ provider is not registered on the the local machine

both my client and server have this file: at the same version 6.?.? version:

Vfpodbc.dll

For grins I reinstall the foxpro odbc driver on the server and see this event:

Product: Visual FoxPro ODBC Driver Configuration Completed successfully.

Same error.. I attempt to manually register it on the server and I get this:

 c:windowssyswow64vfpodbc.dll was loaded, but the dllregisterServer entry point was not found. The file can not be registered.

Same error…

I found this post.. but do ever get an option to select «For everyone»

http://forums.asp.net/t/1138178.aspx