September 5, 2002 at 8:52 am
Anyone seen, or can explain the following error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Excel Driver] System resource exceeded.]
Scenario: Spreadsheet on my C drive with a column of numbers. Running this query from my local server produces the desired results:
SELECT * FROM OPENROWSET
('MSDASQL','Driver=Microsoft Excel Driver (*.xls);DBQ=c:\test.xls','SELECT * FROM "Sheet1$"')
But running this query from another server, back to my spreadsheet, produceses the error above:
SELECT * FROM OPENROWSET
('MSDASQL','Driver=Microsoft Excel Driver (*.xls);DBQ=\\renisxxmtro\c$\test.xls','SELECT * FROM "Sheet1$"')
Any ideas? I would like to avoid creating a linked server connection.
Be great!
Mike
Be great!
Michael
September 6, 2002 at 5:17 am
Has to do normally with the account Agent or SQL itself are running under. If LocalSystem then it cannot see remote drives even mapped drives since it cannot login. This is also based on the users login I do believe which if you use a SQL account is locked to what SQL has access to, if a NT domain user account then as long as it has access to the remote share it should work. You can if needs be setup a domain account for SQL Server and Agent to run under but make sure the password never expires and is not easy for anyone to guess.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply