dcsimg
Results 1 to 2 of 2

Thread: Linked Server from SQL Server 2005 to Oracle Issue

  1. #1
    Join Date
    Feb 2009
    Posts
    1

    Linked Server from SQL Server 2005 to Oracle Issue

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Can you query base table on Oracle via linked server?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •