February 25, 2016 at 2:33 pm
Hello,
I am trying to update column using this query:
update BIOGRAPH_MASTER set UDEF_1A_1=(select bulkColumn from openrowset(bulk 'mdrive\jenzabar2\images\4359099.JPG',single_blob) as x) ;
and I get following error:
Msg 4861, Level 16, State 1, Line 1
Cannot bulk load because the file "mdrive\jenzabar2\images\4359099.JPG" could not be opened. Operating system error code 3(The system cannot find the path specified.).
How can I update udef_1_A column??
February 26, 2016 at 9:45 am
OS errors are typically permission or path errors.
This isn't about SQL, this is the service not being able to find/open the file itself.
February 26, 2016 at 11:19 am
In addition to Steve's reply: you have to understand that the query runs on the server, not on your workstation. That may impact the interpretation of the path.
Also, the file is accessed by the SQL Server service account, not by you. So check that the service account has permissions.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply