June 15, 2007 at 8:30 am
When I execute:
SELECT
*
FROM
OPENDATASOURCE
('Microsoft.Jet.OLEDB.4.0',
'Data Source=\\Pfc-file-srvr\common\CompanyMgmt\BEST.XLS;
Extended Properties=Excel 8.0')...CMS_BEST$
I Get the following error message. What am I missing?
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.].
Msg 7399, Level 16, State 1, Line 59
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.
The Redneck DBA
June 15, 2007 at 11:12 am
OK. Got that working. Apparently OPENDATASOURCE doesn't like UNC. So I just added a section to my script that copies the file to the db server, and the OPENDATSOURCE works.
The problem now is when I try to execute a sp that
1) Copies the file to the DB server and then
2) Runs the code with the OPENDATASOURCE
it blows up because it's smart (or dumb) enough to be checking and realizing the file isn't there, so won't execute.
Can anyone think of a way arround that problem? I don't want to open up the DB server's drive to let people put things in it, I'd prefer to have my script move it...that way I can at least halfway check it...file name, etc.
Thanks,
Jason
The Redneck DBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply