Forum Discussion

Copper Contributor

Jul 29, 2020

Solved

stored procedure to fetch image data from sql server 2005 and save to file

syntax error perty @Obj ,'Type',1; EXEC sp_OAMethod @Obj,'Open'; EXEC sp_OAMethod @Obj,'Write', NULL, @ImageData; EXEC sp_OAMethod @Obj,'SaveToFile', NULL, @Path2OutFile, 2; ...

wasim_ahmad

Jul 29, 2020

wasim_ahmad

change the concatenation got syntax error near ','

SET @Path2OutFile =  +" - "(         @ImageFolderPath

,'\'
         , @Filename
         );

wasim_ahmad

Copper Contributor

Jul 29, 2020

wasim_ahmad

change the concatenation got syntax error near ','

SET @Path2OutFile =  +" - "(         @ImageFolderPath

,'\'
         , @Filename
         );