Hi All I have an SQL Server which is connected to NetSuite via the ODBC Driver. Data is fetched from NetSuite using OPENQUERY commands in Stored Procedures. There are times when the driver completely fails with the following error.

The OLE DB provider "MSDASQL" for linked server "NS64" reported an error. The provider reported an unexpected catastrophic failure.
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "NS64"

After this error, I can no more connect NetSuite. The only solution here is to restart SQL Server Service. There is no warning to this and it happens just randomly sometimes 1-2 times a week and sometimes not even for weeks. Is there a way I can debug this and fix this issue?