Oracle linked server error

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
LVL 1
LobregonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
LobregonConnect With a Mentor Author Commented:
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
 
MaxterJFCommented:
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
 
LobregonAuthor Commented:
No that didn't work... I can query it just fine within an Oracle SQL Developer Screen.
PrtScr-capture-15.jpg
0
 
riazpkCommented:
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
 
LobregonAuthor Commented:
Yeah I can see it... Just cant Query it....
PrtScr-capture-16.jpg
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.