Posted by Ed Murphy on 12/15/06 16:11

Gugale at Lincoln wrote:

> 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.

Does it work if you map the share to a drive letter on the SQL server?

[Back to original message]