| Sergey Okhotny 2002-11-11, 10:24 am |
| I'm trying to execute simple query:
SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source=" \\xvndkhdev011\Projects\faxlog
.xls";Extended
properties=Excel 8.0')...faxlog$
But I get error "OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an
error. The provider did not give any information about the error." in case
when I connect using Integrated Security on SQL Server and file is placed on
network.
When I connect using UserID(ie sa) the script works normally.
When I'm using localy placed file (on the same machine where SQL server is)
it works too.
When I connect to SQL server on the same computer where ActiveDirectory
Server placed the script works too.
But using Integrated Security, network path to file is mandatory.
So some HELP ME!!!
ICQ: 60198689
|