Posted by Gugale at Lincoln on 12/15/06 07:11

Hi,




I am not able to execute following command from computers other than the SQL
server itself.

select * from openrowset(bulk N'\\ImageServer\Model\Cam_05.dwg',
SINGLE_BLOB) as doc

I get following error message:

Msg 4861, Level 16, State 1, Line 1

Cannot bulk load because the file "\\ImageServer\Model\Cam_05.dwg " could
not be opened. Operating system error code 5(Access is denied.).




If I use local file path and keep the file on the SQL server then it works
fine from any computer.

select * from openrowset(bulk N'D:\Model\Cam_05.dwg', SINGLE_BLOB) as doc



The network share has read access for everyone.



What should I do to make it work? I am not allowed to move the files and the
application which loads them to the SQL server.



Thanks

Sachin G

• Next in forum: max degree parallelism
• Prev in forum: Re: Opinion about design needed (splitting string data)
• Thread view: OPENROWSET and network share

[Reply to this message]