September 25, 2011 at 1:43 am
hello all.
I want to use vfpoledb provider in sql server 2008 and windows server 2008 and download vfpoledb from http://www.microsoft.com/download/en/details.aspx?id=14839
and run this query :INSERT INTO OPENROWSET('VFPOLEDB', 'dBase IV;Database=C:\Temp;','select * from dskwor00')select * from test
but get error:Cannot create an instance of OLE DB provider "VFPOLEDB" for linked server "(null)".
then exec this :sp_configure 'show advanced options', 1
reconfigure
go
sp_configure 'Ad Hoc Distributed Queries', 1
reconfigure
go
sp_configure 'show advanced options', 0
reconfigure
go
USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N'VFPOLEDB', N'AllowInProcess' , 1
GO
USE [master]
EXEC master.dbo.sp_MSset_oledb_prop N'VFPOLEDB' , N'DynamicParameters' , 1
GO
now get error:OLE DB provider 'VFPOLEDB' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
what do i do for solve this error?is there vfpoledb for win server 2008?please help me.
September 25, 2011 at 10:24 am
As I do not have Visual FoxPro I can't help you much in this but I suppose you did create a linked server and did configure it under the advanced properties, tested it with a select and that it worked.
vfoxpro OLEDB is no more suppoerted (http://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx) and it seems there might be some issues in statements different from Select, according to this forum post, here in SSC http://www.sqlservercentral.com/Forums/Topic685670-149-1.aspx#bm732326.
Hope this helps!
March 15, 2013 at 7:10 am
The Visual Foxpro OLEDB driver is supported at the time of writing, as is Visual FoxPro itself. The ODBC driver is not supported.
March 15, 2013 at 3:36 pm
Thanks Alan,
my mistake! To complete your answer, MSDN says:
"Visual FoxPro ODBC Driver
The VFPODBC driver is no longer supported. We strongly recommend using the Visual FoxPro OLE DB provider as a replacement. Please refer to the following article for more information and related links to issues when using the VFPODBC driver: http://support.microsoft.com/kb/277772."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy