|
|
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?
Navigation:
[Reply to this message]
|