?
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
?
535 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 77

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 77

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 77

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 77

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 77

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

765 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