Servidor vinculado

  • hola un favor estoy intenando hacer una consulta de dbf por medio de sql 2008 (analizador de consulta) y me sale el error, no se que mas me falta para darle permiso y que la consulta se efectua bien, gracias por su respuesta, el mismo codigo lo hize correr bien en el sql 2005. Gracias por su respuesta de antemano

    EXEC sp_addlinkedserver

    @server = 'VFProducto',

    @srvproduct = 'VFP',

    @provider = 'VFPOLEDB.1',

    @datasrc = 'D:\Pacon\ContaWMG\W001'

    SELECT * FROM VFProducto...Cta2010

    --Error

    Mens. 7302, Nivel 16, Estado 1, Línea 1

    No se puede crear una instancia del proveedor OLE DB "VFPOLEDB.1" para el servidor vinculado "VFProducto".

    --sql server

    select @@VERSION

    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 6.1 <X86> (Build 7600: )

  • Google Translation of Lowell's Response (9/16/2010)


    se ve como un controlador OLE nombre específica VFPOLEDB.1 necesita ser instalado en su servidor.

    el conductor probablemente ya existe ont que otro servidor, por lo que trabaja allí.

    it looks like a specific OLE driver named VFPOLEDB.1 needs to be installed on your otehr server.

    the driver probably already exists ont he other server, which is why it works there.

    Google Translate (9/16/2010)


    Hi Type text or a website address or translate a document.

    Cancel

    ListenSpanish to English translation

    hola a favor I'm intention to make a query through sql dbf 2008 (Query Analyzer) and I get the error, but do not know what I need to give permission and that the query is performed well, thanks for your reply, the same I did the code run well in the sql 2005. Thanks for your reply in advance

    EXEC sp_addlinkedserver

    @ Server = 'VFProducto'

    @ Srvproduct = 'VFP'

    @ Provider = 'VFPOLEDB.1'

    @ Datasrc = 'D: \ Pacon \ ContaWMG \ W001'

    SELECT * FROM Cta2010 VFProducto ...

    - Error

    Mens. 7302, Level 16, State 1, Line 1

    Can not create an instance of OLE DB provider "VFPOLEDB.1" for linked server "VFProducto."

    - Sql server

    select @ @ VERSION

    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 6.1 <X86> (Build 7600:)

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • The Visual Foxpro ODBC/OLE driver was in one of those DAO packs. You can also get the latest driver here:

    http://www.microsoft.com/downloads/en/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • SysEdw (9/16/2010)


    hola un favor estoy intenando hacer una consulta de dbf por medio de sql 2008 (analizador de consulta) y me sale el error, no se que mas me falta para darle permiso y que la consulta se efectua bien, gracias por su respuesta, el mismo codigo lo hize correr bien en el sql 2005. Gracias por su respuesta de antemano

    EXEC sp_addlinkedserver

    @server = 'VFProducto',

    @srvproduct = 'VFP',

    @provider = 'VFPOLEDB.1',

    @datasrc = 'D:\Pacon\ContaWMG\W001'

    SELECT * FROM VFProducto...Cta2010

    --Error

    Mens. 7302, Nivel 16, Estado 1, Línea 1

    No se puede crear una instancia del proveedor OLE DB "VFPOLEDB.1" para el servidor vinculado "VFProducto".

    --sql server

    select @@VERSION

    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 6.1 <X86> (Build 7600: )

    Heh... tell ya what. How about YOU run it through the translator next time. Thanks.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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