Post reply

OLE DB Provider

  • October 11, 2007 at 7:48 am

    #178924

    Hi,

    We run a job that updates tables on another server and it worked fine for two years but now we are getting the error below. The crazy part is that it only happens once in a while.

    The job runs every day at 1 am.

    Can anyone help me with this and I have researched this issue but with no success.

    Sql server 2000 sp3

    Executed as user: Domain_name\MSSQL. OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.

  • October 11, 2007 at 7:53 am

    #741207

    just guessing at this point without more information as to what the step was actually doing, but...

    could it be the login that is being used has had it's password changed?

    or that the database it is trying to execute against has had that logins permissioned removed, either deliberately or because it was restored from a backup/recreated?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 15, 2007 at 1:06 pm

    #742117

    Thank you for your suggestions. I should have offered more information. A database on one server is updating tables on another server. This process runs at midnite and worked fine until just a couple of weeks ago. The really strange thing about it is that it does still work occasionally. There does not seem to be any rhyme or reason why it fails only some of the time.

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

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