Servidor vinculado

Question

Servidor vinculado

SysEdw

SSC Veteran

Points: 270
More actions
September 16, 2010 at 2:43 pm

#224078

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: )

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

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

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!

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

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?

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

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)