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.

"Gugale at Lincoln" <gugale.newsgroup@gmail.com> wrote in message
news:YUrgh.25003$9v5.24749@newssvr29.news.prodigy.net...
> 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
>
>
>
>
>
>