Linked server to Oracle-Openquery

• Dhruva_51

  SSChampion

  Points: 10521

  More actions

  June 13, 2012 at 12:01 pm

  #104154

  Hi all,

  Env: Oracle 11R2 64 bit, sql server 2008 R2 64 bit SP1

  I was able to setup the Linkedserver to Oracle server using ODBC connection and was tested successfully.

  But when i run the OPENQUERY statement i am not retreiving the total rows exists in oracle table.

  Query is returning only few rows out of all.

  Here is the sample query i am running-

  select * from openquery ([Oracle_ServerName],

  'select * from schemaname.testtable' )

  Does any one faced the same issue?.

  Thanks,

• Dhruva_51

  SSChampion

  Points: 10521

  More actions

  June 13, 2012 at 1:06 pm

  #1500630

  PLease help on this issue..