-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|