Executing a Query with a Date in the Where Clause Returns No Rows Using the Oracle Provider for OLEDB with Linked Server in SQL Server 2005 and an Oracle Database (Doc ID 782761.1)

Last updated on JULY 10, 2017

Applies to:

Oracle Provider for OLE DB - Version 8.1.7.4 and later
Microsoft Windows (32-bit)
Microsoft Windows Itanium (64-bit)
Microsoft Windows x64 (64-bit)

*** Checked for relevance on 10-Jul-2017 ***

Symptoms

Executing a Query with a date in the where clause returns no rows using the Oracle Provider for OLEDB with Linked Server in SQL Server 2005 and an Oracle Database. The same query returns 28 rows with the MS OLEDB Provider.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms