Unanswered: Load a doc to VARBINARYT(MAX) FileStream
Im trying to load a document into a column defined as data type VARBINARY(MAX) in a FileStream database. However, I keep get the following error. Please can someone tell me what im doing wrong?
DECLARE @img AS VARBINARY(MAX)
-- Load the image data
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(BULK 'C:\Users\C# Trader\Documents\Test.doc', SINGLE_BLOB ) AS x
-- Insert the data to the table
INSERT INTO Items (ItemID, ItemNumber, ItemDescription, ItemImage)
SELECT NEWID(), '1002','Mouse', @img
Msg 3634, Level 16, State 1, Line 34
The operating system returned the error '0xc000003a(failed to retrieve text for this error. Reason: 15105)' while attempting 'NtCreateFile' on 'C:\SQL Server Databases\DB1_FileGroup1_FS\cdea2ac1-2cea-433b-8117-8d6407871e39\922109cf-b0c6-4991-90db-0f6c2c6ebda5\00000014-00000284-00bb'.
The statement has been terminated.