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
532 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 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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 500 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.

726 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