RE: Hooking up an Oracle Linked Server...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: CJ Butcher (cj_at_eikeconsulting.com)
Date: 02/17/04 

Date: Tue, 17 Feb 2004 15:17:11 -0800

I ran the DBCC command and then reran the select statement, here is the
error I got back.

Server: Msg 7357, Level 16, State 2, Line 1
Could not process object '"WEBSTATS"."ACCOUNTS"'. The OLE DB provider
'OraOLEDB.Oracle' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to
process object, since the object has no
columnsProviderName='OraOLEDB.Oracle', Query="WEBSTATS"."ACCOUNTS"'].

Now this is very odd, as I know there are columns in the table and
several thousand rows as well. Upon further investigation I did find
that the ACCOUNTS table is actually a SYNONYM and not a table. However
if I do a Describe ACCOUNTS in Oracle, it returns the correct column
definitions.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Execute without reporting errors
    ... Andrew J. Kelly SQL MVP ... The OLE DB provider 'SQLOLEDB' ... > unable to process object, ... >>> I execute an insert into stmnt with source the ...
    (microsoft.public.sqlserver.programming)
  • Re: Execute without reporting errors
    ... Hello Andrew, thank you responding on this, it didn't ... Could not process object 'exec sp_MSdependencies ... OLE DB error trace [Non-interface error: ...
    (microsoft.public.sqlserver.programming)
  • Calling stored procedures on an AS400/DB2 using linked server - PRETTY DESPERATE
    ... Could not process object ''. ... OLE DB error trace [Non-interface error: OLE DB provider MSDASQL ...
    (microsoft.public.sqlserver.server)
  • OPENROWSET problem
    ... this error: "OLE DB error trace [Non-interface error: OLE DB provider ... unable to process object, since the object has no columns" ...
    (microsoft.public.sqlserver.programming)
  • SQL with Sybase
    ... There is a SP on Sybase ... Could not process object 'exec sp_test "TEST"'. ... The OLE DB ...
    (microsoft.public.sqlserver.connect)