Forum Stats

  • 3,767,811 Users
  • 2,252,720 Discussions
  • 7,874,334 Comments

Discussions

SSRS Preview / Oracle Data Source "An attempt has been made to use a data extension ORACLE'

Configuration

Windows 10 x64 Pro Visual Studio 2019 (repaired) Extension: Reporting Services Projects (Latest) Extension: Oracle Developer Tools (Latest) Oracle Client: ODAC1931_x64

Problem

When using an Oracle Data Source in SSRS, the connection works, and a Query of the Data Source works (it returns values you'd expect from the SQL), but the Preview view fails immediately with

An error occurred during local report processing. An attempt has been made to use a data extension ORACLE that is either not registered with this report server or is not supported in this edition of Reporting Services.

SSRS Report Designer can make a valid connection, and make a data source that seems to work, but preview fails.

visual-studio

Answers