Solved

ODP.NET installed but now I think there might be two oracle homes? cannot connect anyway....

Posted on 2011-03-16
8
720 Views
Last Modified: 2012-05-11
Hi,

I was trying to install ODP.NET there, and that went ok. It installed to E:\oracle\product\10.2.0\client_1... But, the thing is I already have an oracle home under E:\oracle\ora92

So, I can connect OK using the ODACHome1 using TOAD and I can connect to the original home ORAHome92 ok. However, when I try it through code I get an error 'ORA-12154: TNS:could not resolve the connect identifier specified'.

I think this is probably because the default home is ORAHome92 and probably I need to set it to ODACHome1. Or, somehow I need to specify that the ODP.NET code should use ODACHome1. Well, I'm just guessing there really. What should I do to fix this? (I'm using VS 2005; VB.NET)

Thanks Aiden
0
Comment
Question by:AidenA
[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
  • 2
8 Comments
 
LVL 35

Accepted Solution

by:
johnsone earned 250 total points
ID: 35147759
Within the original home, there should be a tnsnames.ora file.  If you copy that file to the new home, in the same place (the network\admin directory), that should let you use either home directory.
0
 

Author Comment

by:AidenA
ID: 35147840
Hi thanks, yes i tried that but it didn't work. Are you sure that the default home being the wrong one isn't a problem?
0
 
LVL 35

Expert Comment

by:johnsone
ID: 35148200
The ORA-12154 error would indicate that something is incorrect with the tnsnames.ora file, or the connect string.

You should be able to change the default home with the home selector utility.
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

Author Comment

by:AidenA
ID: 35148343
ok but tnsnames.ora was working fine absolutely no problems until i just installed ODP.NET. so clearly that changed something. Now, even if I try and use my previous method of connecting (OraOLEDB.Oracle) it is producing this error. I'll have a check about this home selector but if i look at the environmental variables they show:

E:\oracle\product\10.2.0\client_1\bin;E:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;

as the first few environmental variables... I tried to remove the first one just to see if i could connect as i did before the installation... but no luck...
0
 

Author Comment

by:AidenA
ID: 35149007
ok this is starting to get bad. still trying to just get my original connections working and now getting a The 'OraOLEDB.Oracle' provider is not registered on the local machine

think i'm just going to try and uninstall ODP.NET...
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 35149104
Oledb error is like a PATH issue.  Put the old home in the path first.

For the tns error: set an environment variable TNS_ADMIN pointing to the folder with the correct tnsnames.ora file.

I would suggest the env var as a test.  Once you get it working we can get the file in the proper place.
0
 

Author Comment

by:AidenA
ID: 35275101
i was busy on something else there... but will start back on this on friday i think... and I think also i'll have to go with ODP.NET after all since I inadvertently convinced others to go with it to!

the OraOLEDB.Oracle started working by itself i think just after i turned off the machine and came in the next day... so I just need to get ODP.NET working again... i'll let you know how I go on that and check your suggestions
0
 

Author Comment

by:AidenA
ID: 35727549
actually i managed to solve this issue but can't remember how exactly... i think it might have just been a coding issue. Either way I'll just close off this question and won't add to knowledge base...

thanks for help...
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

730 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