AnsweredAssumed Answered

PIOLEDBENT Linked server SQL errors

Question asked by mavd on Aug 4, 2015
Latest reply on Aug 14, 2015 by bshang

Hi

 

Context: On a SQL Server 2008 R there is a linked server pointing to AF (2.4.0.4431) using the PIOLEDBENT provider (Options: Dynamic parameter, Nested Queries, Supports 'Like' operator)

 

On this SQL Server there are several SQL jobs scheduled to run at each 2 or 10 minutes calling stored procedures (from different databases) that are using the linked server.

 

Once in a while (sometimes more than once a day) those jobs are failing for different reasons but it is always related to the linked server.

 

Here is a list of the different errors that happen:

 

- Cannot get properties from OLE DB provider "PIOLEDBENT" for linked server "MESAF". [SQLSTATE 42000] (Error 7372).  The step failed.

- Could not execute statement on remote server 'MESAF'. [SQLSTATE 42000] (Error 7215).  The step failed.

- Cannot initialize the data source object of OLE DB provider "PIOLEDBENT" for linked server "MESAF". [SQLSTATE 42000] (Error 7303).  The step failed.

- The attempt by the provider to pass remote stored procedure parameters to remote server 'MESAF'  failed. Verify that the number of parameters, the order, and the values passed are correct. [SQLSTATE 42000] (Error 7213).  The step failed.

- The OLE DB provider "PIOLEDBENT" for linked server "MESAF" reported an error. The provider reported an unexpected catastrophic failure. [SQLSTATE 42000] (Error 7399)  Cannot initialize the data source object of OLE DB provider "PIOLEDBENT" for linked server "MESAF". [SQLSTATE 42000] (Error 7303).  The step failed.

 

When one of these errors occurs, nothing is done to fix the problem. The jobs were running correctly before the error occurred and will continue working on the next execution until one of these errors occurs again.

 

Has anyone seen these errors before or knows how to fix them?

 

Thanks,

Veronique

Outcomes