Error 80004005

Question

Post reply

Error 80004005

PREETHI MOHAN

SSC Enthusiast

Points: 122
More actions
August 17, 2006 at 2:00 pm

#119324

Hi all,

I have a DTS package which access a access file in shared drive. when i execute it manually it is not giving error. But when I schedule it , it is giving the follwoign error

Error: -2147467259 (80004005); Provider Error: -534774783 (E01FFC01) Error string: 'S:\Application Development\Ram\ELib_CMF_Feed.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

I checked the permission of the account under which the sqlagent runs. It is fine. Even I logged in using that account and tried to run the package manually. It ran successfully. So I don't understand what is going on.

If somebody helps me that would be great.

Thanks,

Preethi Mohan.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Prema sambandam SSCommitted Points: 1825 More actions · Answer 1

Prema sambandam

SSCommitted

Points: 1825

August 18, 2006 at 7:04 am

#655621

Hi Preethi:

you have to type full absolute path. like \\ApplicationDevelopment\Ram\Elib_cmf_feed.mdb.

PREETHI MOHAN SSC Enthusiast Points: 122 More actions · Answer 2

Thanks,

I did that, but I'm gettign the follwoing error now. When I tried to open it with that account it is not giving any error. But when I try to run it it is giving the following error.

Error = -2147467259 (80004005) Error string: The Microsoft Jet database engine cannot open the file '\\ammhinmul2\shared\Application Development\Ram\ELib_CMF_Feed.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Thanks,

Preethi Mohan.