Home Forums SQL Server 2008 Working with Oracle Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server RE: Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server

  • The problem seems to be resolved by trimming the field used in the WHERE clause, although I'm not sure why. The field is a INT, but when I apply an LTRIM and an RTRIM, the query works. Why would this be the case?