Post reply

OLE DB provider 'VFPOLEDB' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

  • September 25, 2011 at 1:43 am

    #257733

    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

    #1386223

    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!

    MCITP Database administrator 2008
    MCTS SQL Server 2008 Implementation and maintenance
    MCTS Sharepoint configuration
    MCP Designing Deploying and Managing a Network Solution for the Small and Medium-sized Business
    ITIL V3 Foundation

  • March 15, 2013 at 7:10 am

    #1597480

    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

    #1597734

    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."

    MCITP Database administrator 2008
    MCTS SQL Server 2008 Implementation and maintenance
    MCTS Sharepoint configuration
    MCP Designing Deploying and Managing a Network Solution for the Small and Medium-sized Business
    ITIL V3 Foundation

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply