Unanswered: Linked server of Sql Server to Oracle issue
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".
1.Do u have Oracle client tools installed in Server in which u have SQL server 2.You need to put entry in tnsnames.ora for the oracle server and try to do tnsping and also have a look at sqlnet.ora.
3.Create a ODBC with id which is pointing to oracle linked server and test the connection