Openrowset across a network

[Mustafa Ismail Mustafa]

This should work, but it keeps returning a "could not be opened. Operating system error code 5(Access is denied.)."

select * from Openrowset (BULK '\\nvBeast\dropzone\img.jpg',SINGLE_BLOB) AS [Image]

Googling shows that many have the same problem, but I could not find any answers. Anyone got a clue?

If the post was helpful, please vote, eh! Current activities: Book: Devils by Fyodor Dostoyevsky Project: Hospital Automation, final stage Learning: Image analysis, LINQ Now and forever, defiant to the end. What is Multiple Sclerosis[^]?

[Henry Minute]

Have you read the Books Online ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/18a64236-0285-46ea-8929-6ee9bcc020b9.htm, the Security Considerations section?

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[Lost User]

nice link.

Thanks and Regards Sujit Kr. Mandal

[Md Marufuzzaman]

OPENROWSET: Includes all connection information necessary to access remote data from an OLE DB data source. This method is an alternative to accessing tables in a linked server and is a one-time, ad hoc method of connecting and accessing remote data using OLE DB. The OPENROWSET function can be referenced in the FROM clause of a query as though it is a table name. The OPENROWSET function can also be referenced as the target table of an INSERT, UPDATE, or DELETE statement, subject to the capabilities of the OLE DB provider. Although the query may return multiple result sets, OPENROWSET returns only the first one. If you use any network path, please confirm that your SQL login user is permitted to perform bulk load on the Operating System.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

---

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. Thanks Md. Marufuzzaman