Re: Hooking up an Oracle Linked Server...

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

Date: Tue, 17 Feb 2004 22:09:34 GMT

Hi Vikram,

I have read both articles, many times. I ran the DBCC statement and then
reran the select, this is the error message 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"'].

I get the same error if I run the select or use OPENQUERY. This is very odd
as I know that the table has 24 columns and several thousand rows. Upon
further investigation, I did find out that the ACCOUNTS table is actually a
synonym, not a real table. However, if I log into Oracle and do a "describe
ACCOUNT" I do get the correct column definitions.

CJ
"Vikram Jayaram [MS]" <vikramj@online.microsoft.com> wrote in message
news:j9eVryZ9DHA.2052@cpmsftngxa07.phx.gbl...
>
> CJ,
>
> 1. Does this happen for only this 1 query?
> 2. Please do the following -----------
>
> dbcc traceon(7300)
> --- Then run the query.
>
> Please let me know what the error returned is. You will get an extended
> error message.
>
> 3. You could also read the following articles from our Knowledge Base---
>
> Q280106 HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL
> Q259959 INFO: Steps to Debug Connectivity Issues to an Oracle Server
>
> 4. Does this SELECT query work when called as OPENQUERY?
>
> Thanks.
>
> Vikram Jayaram
> Microsoft, SQL Server
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>
>

Relevant Pages

  • ORA-12705: invalid or unknown NLS parameter value specified
    ... A linked server to Oracle return SOMETIMES this error message: ... [OLE/DB provider returned message: ORA-12705: invalid or unknown NLS ... On an other SQL Server machine a linked server to the same Oracle server ...
    (microsoft.public.sqlserver.connect)
  • RE: The object invoked has disconnected from its clients.
    ... The latest server Usage Report email only contained this error message. ... It is recommended that you contact Microsoft Customer ... Support Services via telephone so that a dedicated Support ... Professional can assist you recover the server in a more efficient manner. ...
    (microsoft.public.windows.server.sbs)
  • Re: startx fails
    ... Subject: startx fails ... Have you looked in the paths shown in the error message? ... configure the netscape http server. ... install, or one on which people have done lots of patches? ...
    (comp.unix.sco.misc)
  • Re: Publishing WebForms to Production System
    ... Its already Off but same error message. ... <!-- CUSTOM ERROR MESSAGES ... Set trace enabled="true" to enable application trace logging. ... > and upload the modified web.config file to your server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Publishing WebForms to Production System
    ... Its already Off but same error message. ... <!-- CUSTOM ERROR MESSAGES ... Set trace enabled="true" to enable application trace logging. ... > and upload the modified web.config file to your server. ...
    (microsoft.public.dotnet.framework.aspnet)