How do I do a SELECT on an ODBC connection

[robmoors]

I am trying to use a SELECT statement against an Oracle ODBC connection and it's telling me that it can't find the object(table). How do I create that statement?

Thank you in advance :>

 

[bperry]

I am wondering if you will get a faster or more satisfactory reponse if you post this problem in the Oracle forum?

bp

 

[Rizla]

try this.

select * from openquery ( {Linked Server Name} ,'select * from {Table}')