Solved

Oracle linked server error

Posted on 2010-09-01
6
294 Views
Last Modified: 2012-05-10
Hello All,

I am trying to query an Oracle database from a linked 2005 SQL Server. I am pretty sure the error has something to do with the table name being DOCUMENT. I can query all other tables in the server except this one one, I even put the table name in brackets and get the same error(s). Code
0
Comment
Question by:Lobregon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 2

Expert Comment

by:MaxterJF
ID: 33582105
It's true that DOCUMENT is a reserved word in Oracle.  If you call "SELECT * FROM "EMRTST2".."ML"."DOCUMENT" that should be working (it's true that it's Pervasive way to call objects but oh well.... why not to try it?)
0
 
LVL 1

Author Comment

by:Lobregon
ID: 33582147
No that didn't work... I can query it just fine within an Oracle SQL Developer Screen.
PrtScr-capture-15.jpg
0
 
LVL 13

Expert Comment

by:riazpk
ID: 33584174
If you have SQL Server Management Studio, just check whether you can see the table when you choose the following options:
Linked Servers -> EMRTST2 -> Catalogs -> default -> tables
0
 
LVL 1

Author Comment

by:Lobregon
ID: 33588930
Yeah I can see it... Just cant Query it....
PrtScr-capture-16.jpg
0
 
LVL 1

Accepted Solution

by:
Lobregon earned 0 total points
ID: 33589121
I ended up making of a view of the table in Oracle and querying that view via SQL Server... I know just a band-aid but it works.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question