Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Linked Server: OLEDB_ERRORS

Author  Topic 

Carat
Yak Posting Veteran

92 Posts

Posted - 2008-10-15 : 08:23:01
I'm using event notifications to catch errors that occur with Linked Servers by using the eventtype 'OLEDB_ERRORS'. Everything seems to be working well but in fact I have a lot of errors. This is an example of a message:

<EventType>OLEDB_ERRORS</EventType>
<PostTime>2008-10-04T02:00:52.850</PostTime>
<SPID>141</SPID>
<TextData><hresult>-2147467259</hresult>
<inputs>
</inputs>
</TextData>

Can anyone tell me what could be the problem?

SimpleSQL
Yak Posting Veteran

85 Posts

Posted - 2008-10-16 : 03:45:56
I think they are benign

168354 INFO: Underlying OLE and OLEDB Provider Errors Are Exposed Through ADO
http://support.microsoft.com/default.aspx?scid=kb;EN-US;168354
Go to Top of Page

Carat
Yak Posting Veteran

92 Posts

Posted - 2008-10-16 : 04:56:10
Thank you, this is exactly what I was looking for.
Go to Top of Page
   

- Advertisement -