Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • Last Modified:

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

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
Rhonda Carroll
Asked:
Rhonda Carroll
  • 5
  • 4
1 Solution
 
slightwv (䄆 Netminder) Commented:
Verify you don't have multiple Oracle installs on the machine.  sqlplus might be using a different one than SSRS.
0
 
Rhonda CarrollAuthor Commented:
Sorry its not 10g but 9.5, this is the only instance on my laptop.
0
 
slightwv (䄆 Netminder) Commented:
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Rhonda CarrollAuthor Commented:
Toad for Oracle 9.5 and Oracle 10G, I'll have to find out about the server.
0
 
slightwv (䄆 Netminder) Commented:
>>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
 
Rhonda CarrollAuthor Commented:
She has the exact same versions, out IT department only releases certain versions.

There is absolutely only one Oracle product installed.
0
 
slightwv (䄆 Netminder) Commented:
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
 
Rhonda CarrollAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now