Learn how to a build a cloud-first strategyRegister Now

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
?
538 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
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 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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

810 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