Programmazione:Nozioni varie

Soluzioni

Errori

Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for linked server

Ci son diverse soluzioni al seguente errore un pò causale...

1. Impostare "Allow inprocess" nelle proprietà generali del Provider "OraOLEDB.Oracle" sul nodo 'linked servers' si SQL Server.
2. Da stackexchange.com: This particular issue was resolved by removing packet inspection rules on TCP Port 1521 (Oracle default) within the VMWare NSX. This was causing a bottleneck of data coming out of our Oracle infrastructure (IBM AIX) and back into our NSX infrastructure.
3. Da stevesohcot.com.

SET QUOTED_IDENTIFIER OFF
SELECT * FROM OPENQUERY ([inked_server_name_here], "SELECT field_one, field_two, field_with_error ‘ ‘ AS other_field FROM table")

etc

SQL standard 2:

-- Commento
SELECT * 
FROM Tabella
WHERE 1=1

Mappa e Link

---

Oracle

---

MS SQL |

---

Parole chiave: