OPENROWSET

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: Difference between openrowset and opendatasource
    ... No. Openrowset() does not allow you to use 4-part-name. ... >> for an OLE DB provider using the SQL Server DisallowAdhocAccess property. ... >> data source on the network that can be accessed using that OLE DB> provider. ...
    (microsoft.public.sqlserver.programming)
  • Help: Best way to Import data from EXCEL using a TSQL
    ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... Actually, before i try openrowset, i try bulk insert command as well. ... "Ian" wrote: ...
    (microsoft.public.sqlserver.odbc)
  • Help: Best way to Import data from EXCEL using a TSQL
    ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... Actually, before i try openrowset, i try bulk insert command as well. ... "Ian" wrote: ...
    (microsoft.public.sqlserver.datamining)
  • Help: Best way to Import data from EXCEL using a TSQL
    ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... Actually, before i try openrowset, i try bulk insert command as well. ... "Ian" wrote: ...
    (microsoft.public.sqlserver.server)
  • Help: Best way to Import data from EXCEL using a TSQL
    ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... Actually, before i try openrowset, i try bulk insert command as well. ... "Ian" wrote: ...
    (microsoft.public.sqlserver.programming)