[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Can't connect to database with Oracle 10g(32bit) in SQL Server 2008 Reporting Services on a Windows 7(64 bit) OS?

Posted on 2011-09-19
9
Medium Priority
?
539 Views
Last Modified: 2012-08-14
Hi,

I have SSRS 2008 setup on my laptop that runs on Windows 7 (64 bit) and Oracle 10g(32 bit). Everything appears to look fine except when I try to run a report, in which case it just won't connect. It keeps giving me an ora-12154 error but I know for a fact that the tnsnames.ora file is correct, is in the correct location and it will connect through SQL Plus. I have a colleague that has the exact same software and she is working fine without problem. is there a way to fix this issue or do I need to uninstall the works and re-install in a different way to get it to work?

Thanks for your help,
Rhonda
0
Comment
Question by:Rhonda Carroll
  • 5
  • 4
9 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36562003
Verify you don't have multiple Oracle installs on the machine.  sqlplus might be using a different one than SSRS.
0
 

Author Comment

by:Rhonda Carroll
ID: 36562036
Sorry its not 10g but 9.5, this is the only instance on my laptop.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36562083
I don't remember an Oracle version 9.5.  Please confirm the Oracle installed version.

Also confirm the other machine has the same versions and the Bit installs match (64bit to 64bit, 32bit to 32bit).
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 

Author Comment

by:Rhonda Carroll
ID: 36562258
Toad for Oracle 9.5 and Oracle 10G, I'll have to find out about the server.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36562281
>>Toad for Oracle 9.5 and Oracle 10G

And you only have One Oracle product installed?  Tripple check this.

>>I'll have to find out about the server.

What server?  I was referring to the colleague's machine.
0
 

Author Comment

by:Rhonda Carroll
ID: 36562303
She has the exact same versions, out IT department only releases certain versions.

There is absolutely only one Oracle product installed.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36562430
I'm not a SQL Server person and cannot help with that aspect of the question.  99% of the time the ora-12154 is a mis-configured tnsnames.ora file or the application is looking at the wrong one.

Did you check the Bit versions are all the same?

Check your sqlnet.ora and make sure it is using TNS as the default connect type.
0
 

Author Comment

by:Rhonda Carroll
ID: 36711454
How can I check the sqlnet.ora to ensure it is using TNS as the default?  Visual Studio is ok when using SQL as a datasource however when I use oracle as a datasource I get the TNS listener error.  I can access the oracle databases via TOAD so the TNS names are OK.    
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 36711588
Have you confirmed you are not crossing Bit versions?

>>How can I check the sqlnet.ora to ensure it is using TNS as the default?

Check the NAMES.DIRECTORY_PATH entry.

http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/profile.htm#sthref848

>>Visual Studio is ok

Visual Studio or SSRS?

0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question