Linked Server from SQL Server 2005 to Oracle Issue

[Pingii]

Hi all,


I have a Linked Server object in SQL Server 2005 to query an Oracle view. The view returns all table rows.

Linked server name in sql server 2005 is : ASE

Linked Server object in SQL Server 2005 is connecting to Oracle view successfully.


select * FROM OPENQUERY(ASE,'SELECT TOP 1 EMPCODEEIN FROM ASE_VIEW_00050')


My problem while execute the above select query, I am getting below error:

OLE DB provider "OraOLEDB.Oracle" for linked server "ASE" returned message "ORA-00923: FROM keyword not found where expected".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT TOP 1 EMPCODEEIN FROM ASE_VIEW_00050" for execution against OLE DB provider "OraOLEDB.Oracle" for linked server "ASE".


Can any one help me out to resolve the issue?

Thanks in advance.

Thanks
Ping

[rmiao]

Can you query base table on Oracle via linked server?