Re: OPENROWSET

Sol

Hidden shared resource C$ serves for administrative purposes that is why it
is secured by default.

I am not sure that syntax \\server\file.xls is correct because you cannot
share single file - only folder.

In case of \\server\wwwroot$\file.xls there is a (hidden) share
\\server\wwwroot$ that has permissions set so SQL Server can access it.
NB: permissions for shares are both filesystem permissions (in case of NTFS)
and share permissions (most strict).

Martin Rakhmanov

"Sol Rosenburg" <jvandyne@xxxxxxxxx> wrote in message
news:eMo$DEOhGHA.4276@xxxxxxxxxxxxxxxxxxxxxxx
I'm having problems with OPENROWSET with excel file.

I have excel file in network accessible folder. File opens in excel by
entering each of the following in explorer address

\\server\wwwroot$\file.xls
\\server\file.xls
\\server\c$\inetpub\wwwroot\file.xls

However OPENROWSET only works for
\\server\wwwroot$\file.xls
Otherwilse error message returned =
Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider
did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: The provider did not give
any information about the error.].

I think there might be a permissions problem somewhere : maybe domain,
maybe
sql service account. Question is: what context / account is used to
execute
openrowset for each of above?







.

Relevant Pages

  • Re: Cant Write File on Hosted Server...
    ... The host provider has been very responsive and just notified ... me to explain they had to apply permissions for the Network Service account ... byut didn't explain if that was applied to the root of the account to enable ... MSDN - Hosting Multiple ASP.NET Applications ...
    (microsoft.public.dotnet.general)
  • Re: OPENROWSET
    ... Yes...0x80004005 often indicates a permissions issue. ... make sure it has access to the network resources, ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... sql service account. ...
    (microsoft.public.sqlserver.security)
  • Re: Crystal XI troubles
    ... It turned out to be a permissions issue. ... was that I am using the OLE DB provider for Oracle. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is it possible to adjust security for a networked assembly from app.config?
    ... problems due to the permissions required by the ADO.NET provider, ... The temp files that ADO creates on the local machine ... >> When your code attempts to open the target file, does it use a URI with ...
    (microsoft.public.dotnet.security)