Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Linkserver with a photo field

Author  Topic  issam Starting Member 30 Posts Posted - 2008-08-23 : 16:48:27 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