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.
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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\
ASKER
Administrator installed VFP OLE DB and it worked all fine.
ASKER
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?