Next: How to use CDO to send mail with attachment
From: Ram Kumar Koditala on 11 Feb 2005 12:27
We have a scheduled job that is running on a server, which gets the data from
other linked server using SP.

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:

Please help


Thanks,
RK
From: Mike Epprecht (SQL MVP) on 11 Feb 2005 14:46
Hi

0x80004005 means "access denied" in the COM environment.

Check that you have permissions, especially under which account you connect
to the linked server.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike(a)epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Ram Kumar Koditala" <RamKumarKoditala(a)discussions.microsoft.com> wrote in
message news:D460E1EF-7DAA-48E1-A897-6B3A24C024B1(a)microsoft.com...
> We have a scheduled job that is running on a server, which gets the data
from
> other linked server using SP.
>
> 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:
>
> Please help
>
>
> Thanks,
> RK


 | 
Pages: 1
Next: How to use CDO to send mail with attachment