TNS Error With Oracle 10g once user application installed

I have my application running in Visual Studio 2005 with ODP 10.2.0.2.21 and Oracle Client 10.2.0.1.0 (both 32 bit version). The machine I am using is a 64 Bit machine running the 64 bit version of Microsoft Server 2003. When I run my application through the IDE, it runs without any problems. I can also connect to the database through SQL Plus. But, when I create the installation package and install the application on the exact same machine, I start getting the following error: "Oracle.DataAccess.Client.OracleException ORA-12154: TNS: could not resolve the connect identifier specified     at Oracle.Client.OracleException.HandleErrorHelper...." The tnsnames is correct since I can connect through the IDE and SQLPlus and I have checked the GAC and the Environmental Variables and they are all correct. I only have the Oracle Client and the Oracle ODP installed. There are no other versions of oracle on the machine. The machine was also rebooted after the ODP was installed. Any idea of how to fix this?

Thank you,
Susan
LVL 1
sfarleyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
sfarleyConnect With a Mentor Author Commented:
I do not think it is Microsft this time, but Oracle. We had the same problem with Citrix and moving the folder Citrix was installed solved it as well. We have actually had a couple of problems with Oracle on the 64 bit servers.

Thanks,
Susan
0
 
surajgupthaCommented:
Might you be having multiple version of the SQL client installed?
0
 
surajgupthaCommented:
I meant oracle client
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
sfarleyAuthor Commented:
No. This is a very clean machine and I have only instlaled the one version of oracle client and oracle ODP. I did a search just to make sure that no one else had either.
0
 
surajgupthaCommented:
>> Oracle.DataAccess.Client.OracleException ORA-12154: TNS: could not resolve the connect identifier specified     at Oracle.Client.OracleException.HandleErrorHelper...."

When does this happen? on Install or on use of the application ?
0
 
sfarleyAuthor Commented:
Use of the application. I figured it out though. Oracle does not like it when your applicaiton is installed in the Program Files (x86) folder. As soon as I moved my GUI out of that folder, it worked great. Fixed the problem we were having with Citrix as well.

Thanks,
Susan
0
 
surajgupthaCommented:
I would have suspected that if you were using Vista but with Windows Server 2003 i think it might be because the server has been hardenned. In the process they might make certain folders inaccessible to prevent hacking. Thats my guess
0
All Courses

From novice to tech pro — start learning today.