Link to home
Start Free TrialLog in
Avatar of tgatif2000
tgatif2000

asked on

Trying to link FoxPro files in MS SQL Server 2008 via Linked Server

I am trying to link FoxPro files in MS SQL Server 2008 via Linked Server.  However, while doing so, Im getting the following error:

Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB" has not been registered.

I have also installed Microsoft Visual FoxPro OLE DB.  I thought by installing it, it will register it but it did not.
exec sp_addlinkedserver @server = 'temp',
@srvproduct = 'VFP',
@provider = 'VFPOLEDB',
@datasrc='"C:\DbfRestore"'
GO
SELECT * FROM temp...sys1map
GO
sp_dropserver @server = 'temp'
GO

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tgatif2000
tgatif2000

ASKER

I do not Visual Studio installed on the machine.

How can I determine that VFP OLE DB proider is in the list of available providers in SSMS.

How can I find out what is the version of SQL Server?

How can I make the installed provider accessible by this user account?
SQL Server 2008 is 32 bit
1) SSMS is SQL Server Management Studio. Available providers are listed in the Server Objects section.

2) SELECT @@version

3) You have to look in Windows services what user account is used for SQL Server Service. Then you have to look if this account has given access rights to VFP OLE DB provider DLL. You'll find it on the place where you've installed it.
VFPOLEDB.1 is not in listed providers.  The listed providers are being shown in the attachment.

The version is Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)   Jul  9 2008 14:43:34   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Evaluation Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2) (VM).

I have attached the image showing the login for sql server.  However, when I login to a specific database, i used different user/password.
listed-providers.JPG
sql-server-login.JPG
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I installed it but it is still not appearing in the providers list.
Could you please check owner of the vfpoledb.dll? It should be installed in C:\Program Files\Common Files\System\Ole DB\
Administrator installed VFP OLE DB and it worked all fine.