SSRS and Oracle Client

Question

when install oracle client, the SSRS page cannot displayed.

• if only installed oracle driver, SSRS works, and use Oracle data type for data connection, test connection successfully, but when create dataset got error.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

• when using Microsoft OLEDB for Oracle, got

TITLE: Connection Manager
------------------------------

Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.

------------------------------
BUTTONS:

OK
------------------------------

• when use Oracle Provider for OLEDB got:

OraOLEDBpus11.dll: the specified module could not be found.

Answer 1

George,

Is it possible that you are running into a 32bit/64bit issue?  visual studio runs in 32 bit mode.  make sure you have the 32 bit oracle client.  I believe it is common to have both 32 and 64 bit versions installed on servers that run both 32bit and 64 bit application.  Just a thought.  let me know.

Answer 2

Thanks, I did try both 32bit and 64 bit. every time when installed the SSRS reporting error. So I now only installed the drivers, not the instant client, Now I can connect to oracle in SSIS, though still not in SSRS. Not sure how it affects SSRS, might be port conflicts? not likely maybe, as it still asks for login when access SSRS, but soon after login, page not display http 500 error.