Information générale
Forum:
Microsoft SQL Server
Titre:
Linkserver with a photo field
Versions des environnements
SQL Server:
SQL Server 2005
Hi,
I have create a linkserver to read a vfp file with a photo field, the name and file STRUCTURE of vfp as follows:-
/*
ITEMPHOTO TABLE STRUCTURE
VFP: (ITEM_NO CHAR(10),ITEMPHOTO GENERAL)
SQL: (ITEM_NO CHAR(10),ITEMPHOTO IMAGE)
*/
The link server as follows:-
--EXEC SP_ADDLINKEDSERVER
-- @SERVER = N'FOX2', -- YOUR LINKED SERVER NAME HERE
-- @SRVPRODUCT=N'VISUAL FOXPRO 9', -- CAN BE ANYTHING
-- @PROVIDER=N'VFPOLEDB',
-- @DATASRC=N'"C:\BTM\123\DATA1.DBC"'
--EXEC SP_ADDLINKEDSRVLOGIN 'FOX2'
After the server is created i checked to read the file without the photo field it is he read the file with no error, but with the photo field i have the below error :-
SELECT item_no,photo FROM OPENQUERY(FOXPRO,'SELECT item_no,photo FROM ITEMPHOTO')
the error message as follows:-
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB" for linked server "FOXPRO" reported an error. The provider ran out of memory.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "VFPOLEDB" for linked server "FOXPRO".
best regards
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement