Pełny komunikat:
Msg 7399, Level 16, State 1, Line 3
The OLE DB provider „OraOLEDB.Oracle” for linked server * reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 3
Cannot get the column information from OLE DB provider „OraOLEDB.Oracle” for linked server *.
Neleży w Server Objects -> Linked Servers -> Providers dorzucić „Allow inprocess” w danym providerze
Przykładowe zapytania po link serverze do Ora (ku pamięci):
SELECT * FROM OPENQUERY (ORA_LINK, 'SELECT name FROM schemat.tabela’);
DELETE OPENQUERY (ORA_LINK, 'SELECT name FROM schemat.tabela WHERE name = ”wartosc”’);
INSERT OPENQUERY (ORA_LINK, 'SELECT name FROM schemat.tabela’) VALUES (’wartosc’);
UPDATE OPENQUERY (ORA_LINK, 'SELECT name FROM schemat.tabela WHERE id = 2′) SET name = 'wartosc’;