Saturday, March 26, 2011

Popsicle Bridge Plans

VFP + SQL: Be careful when installing the VFP OLEDB Provider

doing some tests with SQL Server Linked Servers, you need to install the OLE DB Provider for VFP 9.0, which download directly from the official site Microsoft.

However, after downloading the installer and have it run without problems, the choice of OLE DB Provider for VFP did not appear in the list of Providers of SQL Server (32 bits).

After several minutes of searching San Google, I found a post which indicated that for some reason the installer did not register the library correctly, and that it should be recorded manually for it to work (although the author of this post is not entirely solved the problem, but that's another story.)

So I opened a command session and run:

CD \\ Windows \\ System32 REGSVR32
vfpoledb.dll

And actually the problem was solved and the choice appeared in the list of providers for SQL Server. So you know, if you need to install the OLE DB provider for VFP, then manually installed must register for work.

And if anyone has any idea why the hell M $ installer does not automatically register as one would expect, please enlighten us with their wisdom.




0 comments:

Post a Comment