Oracle Issue
I have a users that is trying to do the following:
“I am creating a Business Intelligence report using Reporting Services in Visual Studio. The data source is coming from Oracle Database. I need the Oracle client component to connect to oracle.I have attached the screen print with the error message obtained when connecting to oracle using Microsoft Visual Studio 2010.”
The first error the user was getting was that the Oracle Client software needed to be installed. I installed this:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html
She is now getting an error:
ORA-12541 TNS :no listener
Everywhere I read, its stating to make sure the listener service is running. I’ve checked services and even the installation folders and don’t see anything relating to TNSListener. At this point im just spinning wheels and not sure if what I installed was the correct media.
“I am creating a Business Intelligence report using Reporting Services in Visual Studio. The data source is coming from Oracle Database. I need the Oracle client component to connect to oracle.I have attached the screen print with the error message obtained when connecting to oracle using Microsoft Visual Studio 2010.”
The first error the user was getting was that the Oracle Client software needed to be installed. I installed this:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html
She is now getting an error:
ORA-12541 TNS :no listener
Everywhere I read, its stating to make sure the listener service is running. I’ve checked services and even the installation folders and don’t see anything relating to TNSListener. At this point im just spinning wheels and not sure if what I installed was the correct media.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can save yourself a lot of effort if you try to follow my advice. It is best to not having to use those files, but to provide all information with the connection string in the client.
Install directory: %ORACLE_HOME%
files are under: ..\network\Admin
files are under: ..\network\Admin
ASKER
Yes, I installed Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64). It gave me an error that is needed to run in 32-bit, so I installed the 32 bit as well.
I looked in the install directory but do not see any of those config files.