How to solve SSRS error message ORA-12557 TNS protocol adapter not loadable
Problem: When switching from [Design] to
[Preview], you get this error message.
Sometimes, VS might fail to show the ORA 12557 message, but only show a shorter message about a dataset problem.
Diagnose:
How to reproduce the specific error.
Find the Data Source that is failing.
Cick it to open it.
Click [Edit]
Click [Test Connection]
Suggested Solution:
Remove the environment variable ORACLE_HOME during the
execution of Visual Studio; once finished, put it back.
Create a .bat file like this ...
|
@ECHO Off :: remove
%ORACLE_HOME% temporarily IF DEFINED ORACLE_HOME SET
ORACLE_HOME_BACKUP=%ORACLE_HOME% IF DEFINED ORACLE_HOME SET ORACLE_HOME= CALL "C:\Program Files (x86)\Microsoft Visual Studio
12.0\Common7\IDE\devenv.exe" :: restore
%ORACLE_HOME% IF DEFINED ORACLE_HOME_BACKUP SET oracle_home=%ORACLE_HOME_BACKUP% |
Save it as ...
C:\Program Files
(x86)\Microsoft Visual Studio 12.0\Common7\IDE\run_devenv.bat
... being this the location where you have installed
SSRS-Visual-Studio
Consider Changing your shortcut to VisualStudio accordingly.
No comments:
Post a Comment