The OLE DB provider "MSDASQL" for linked server "SERVICENOW" reported an error. The provider reported an unexpected catastrophic failure.Issue ODBC SQL query is not working via SSMS and throws the below error Msg 7399, Level 16, State 1, Line 1The OLE DB provider "MSDASQL" for linked server "SERVICENOW" reported an error. The provider reported an unexpected catastrophic failure.Msg 7330, Level 16, State 2, Line 1Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "SERVICENOW". Connected via ISQL and was able to fetch all the records successfully for the same OLE DB connection. ReleaseODBC - v2.0SSMS - 20.1.10.0ODBC Driver - v18.4.1.1SQL Server Version - 2022 Standard versionResolutionIn SQL Server Management Studio(Run as admin): Follow the below article to update the transaction isolation level to Read Uncommittedhttps://blog.sqlgrease.com/how-to-change-your-default-isolation-level-in-ssms/In ODBC Manager (Run as admin) -> Services -> ServiceNow_ODBC-> Service Settings -> SQL Engine Parameters -> ServiceSQLDiskCachePathUpdate the path to any other path that the user has access to like C://NewFolder (make sure to create the folder)The server team must provide write access to C://NewFolderRestart the server