The provider reported an unexpected catastrophic failure.

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

The provider reported an unexpected catastrophic failure.

Postby bvdberg » Mon Nov 11, 2013 8:40 am

Hi,

I am running a large batch using sql server linked server.
During this batch I get the following errors :

Unknown provider error.
and
The provider reported an unexpected catastrophic failure.

After this I have to reboot my computer in order to use the oledb driver again.
I read on this forum a post that advices to use openquery. But I really don't like rebooting my pc that many times. Does anybody know how to reset the driver?
Or does anybody know the reason for these errors?
Bas
bvdberg
 
Posts: 1
Joined: Mon Nov 11, 2013 8:37 am

Re: The provider reported an unexpected catastrophic failure

Postby Moderator » Mon Nov 18, 2013 11:16 am

Please run PGNP Profiler and see if additional errors information is available in the trace.

If crash occurred in the SQL Server process, then the SQL Server service can be launched from the Services panel (services.msc). Please also consider running the OLEDB provider "out-of-process".

We are investigating the issue.
User avatar
Moderator
Site Admin
 
Posts: 297
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 3 guests

cron