Hi All I have an SQL Server which is connected to ...
# suitescript
s
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.
Copy code
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?
s
You may want to ask this in the #C2A1ZEMF0 room. We also use SQL Server and have a linked server set up to use the ODBC driver, but it has all been working fine for us for many years. I’d make sure you are running up to date and supported versions of SQL Server and using the latest ODBC driver from NetSuite. You could always open a support case with NetSuite to see if they have insights from their end (server logs, etc.) that may help.
s
Thanks @scottvonduhn. I'll check the drivers first and then open a case if needed.