Storing My picture file in database
-
I tried to store the picture present in the MY Picture location of my system but unable to do so Qurey CREATE TABLE StockGifs (StockGifID int NOT NULL, Gif varbinary(max) NOT NULL) INSERT StockGifs (StockGifID, Gif) SELECT 1, BulkColumn FROM OPENROWSET (BULK 'C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills',SINGLE_BLOB) AS x Error Message :Msg 4860, Level 16, State 1, Line 1 Cannot bulk load. The file "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Bluehills" does not exist. Let me know what is the change need to be done Thanks in Advance, Praveen Arokiam
-
I tried to store the picture present in the MY Picture location of my system but unable to do so Qurey CREATE TABLE StockGifs (StockGifID int NOT NULL, Gif varbinary(max) NOT NULL) INSERT StockGifs (StockGifID, Gif) SELECT 1, BulkColumn FROM OPENROWSET (BULK 'C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills',SINGLE_BLOB) AS x Error Message :Msg 4860, Level 16, State 1, Line 1 Cannot bulk load. The file "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Bluehills" does not exist. Let me know what is the change need to be done Thanks in Advance, Praveen Arokiam
-
I tried to store the picture present in the MY Picture location of my system but unable to do so Qurey CREATE TABLE StockGifs (StockGifID int NOT NULL, Gif varbinary(max) NOT NULL) INSERT StockGifs (StockGifID, Gif) SELECT 1, BulkColumn FROM OPENROWSET (BULK 'C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills',SINGLE_BLOB) AS x Error Message :Msg 4860, Level 16, State 1, Line 1 Cannot bulk load. The file "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Bluehills" does not exist. Let me know what is the change need to be done Thanks in Advance, Praveen Arokiam
In the text "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Bluehills" is not a valid name of picture file(if u not remove the extension).
Try "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Bluehills**.jpg" or '.bmp'** or what extension it is.