linkserver - Open Data Connection

• issam mansour

  SSC-Addicted

  Points: 478

  More actions

  September 4, 2008 at 3:41 pm

  #197808

  Hi,

  I create LINKSERVER for vfp database, i use openquery to get the data from the server as follows:-

  select *

  into #VFPCustomer

  from

  OpenQuery( MYVFPSERVER, 'select * from item')

  but i am trying to use the following statment :-

  select * from [MYVFPSERVER]...item

  but i have an error message :-

  Msg 7399, Level 16, State 1, Line 1

  The OLE DB provider "VFPOLEDB" for linked server "MYVFPSERVER" reported an error. The provider did not give any information about the error.

  Msg 7330, Level 16, State 2, Line 1

  Cannot fetch a row from OLE DB provider "VFPOLEDB" for linked server "MYVFPSERVER".

  regards

• krayknot

  SSCertifiable

  Points: 7998

  More actions

  September 12, 2008 at 4:31 am

  #870857

  Try to use the Server name before the table name: as

  [ServerName].[schema].Table

  kshitij kumar
  kshitij@krayknot.com
  www.krayknot.com