DB-Link SQL Server to Oracle OpenQuery Retuns a single row

• philipblahut

  SSC Enthusiast

  Points: 120

  More actions

  August 12, 2012 at 3:24 pm

  #279463

  Hi,

  I'm having an issue with getting openquery to work correctly.

  Im Using:

  SQL server 2008 connecting to Oracle 11g.

  Microsoft OLE DB Provider for ODBC Drivers

  ODBC buffer fetch size is set at 64000

  If I issue this query:

  select * from OPENQUERY(ORACLE_TEST, 'Select * from dbo.defaults')

  I get just the first row returned to me.

  Issuing "Select * from dbo.defaults" in oracle direcly I get 65 rows returned.

  Any assistance would be appreciated!

  Philip Blahut

• Jo Pattyn

  SSC-Dedicated

  Points: 32347

  More actions

  August 12, 2012 at 11:36 pm

  #1524915

  What do you get if you use the Oracle OLEDB drivers for oracle?

• philipblahut

  SSC Enthusiast

  Points: 120

  More actions

  August 13, 2012 at 7:19 am

  #1525038

  Thanks Jo

  Using the Oracle driver seems to work just fine.

• Jo Pattyn

  SSC-Dedicated

  Points: 32347

  More actions

  August 13, 2012 at 11:44 am

  #1525200

  Have a search on fetch on this forum. The oracle default fetchsize is around 200.

  Solved post