May 1, 2008 at 10:31 am
When running the following, I recieve the following err. Any ideas? (IP has been changed :))
insert into OPENROWSET(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=\\999.199.199.99\export\test99.xls;;HDR=YES',
'SELECT * FROM [Sheet1$]')
select * from master..syslogins
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
May 1, 2008 at 12:53 pm
Permissions....
Does the SQL Server service account have permissions to that share on the remote machine?
Alternatively - does the account running the query have read perms on master..syslogins?
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
May 1, 2008 at 1:04 pm
Yes, and
yes.
I orignally had it write to a file on the server. And, I ran a xp_cmdshell to copy a new file to the share in the script and it worked, it it does have privs to connect to the excel.
And, I have SA privs on that server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply