Oracle connection string in vb .net

This is my connection string:
            ordSelCon.ConnectionString = "Data Source=test.world;Integrated Security=no;User ID=GLF;Password=PRIMERA1"
            ordSelCon.Open()

This work fine in my windows form proyect.

Now, I'm developing a windows service inside the same solution. When I use the same connection string inside the service I get the follwing error: ORA-12154 TNS:could not resolve the connect identifier specified.

The TNSNAMES.ORA is on local machine.

It seems to be a permissions problem, I guess but I'm not sure. Also was tested using another account (with administrator privileges) and fails again.

Need help to solve this issue. Thanks
leorochaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

käµfm³d 👽Commented:
What user are you running the service as?
0
leorochaAuthor Commented:
Local System account, but also I've used my personal account. Both with the same problem...
0
käµfm³d 👽Commented:
Do you have multiple home folders?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

guveraCommented:
Please follow the below comments

Comments: 1
===========
Execute lnsrctl services on DR database

The error which you get means that it cannot resolve the connect string given in log_archive_dest_2, have you set NAMES.DEFAULT_DOMAIN in your sqlnet.ora ?

1) ensure that you are checking the correct tnsnames.ora, should be in $ORACLE_HOME/network/admin unless TNS_ADMIN is defined.

2) try suffixing the tns_alias with a domain name in log_archive_dest_2 and tnsnames.ora.

3) you can directly specify the connect string instead of alias in the parameter log_archive_dest_2, something like below ( if this works then you can confirm that the the issue is with tnsnames.ora)

alter system set log_archive_dest_2='SERVICE="(description=(address_list=(address=(protocol=TCP)(host=r00979)(port=1521)))(connect_data=(service_name=desk_std)))", LGWR ASYNC NOAFFIRM' scope=both;

Another Try :
==========
Check if "tnsping <SID>" works from primary (HA) to standby and vica versa.

Sometimes a trailing 'space' in SQL NET configuration (listener.ora,tnsnames.ora) can cause this issue. You may try to check the listener.ora and tnsnames.ora with an expert text editor like notepad++.

Or you may to correct and configuration via netca and netmgr tools.

Also refer the below links.

http://stackoverflow.com/questions/20361325/this-is-error-ora-12154-tnscould-not-resolve-the-connect-identifier-specified
http://kb.tableausoftware.com/articles/knowledgebase/oracle-connection

Hope it may helpful to you.

Thanks
Guvera
0
leorochaAuthor Commented:
Guvera, remember that the same ConnectionString works fine in the same solution in a ORACLETEST windows forms project.

1) I don't have NAMES.DEFAULT_DOMAIN parameter set in SQLNET.ORA (what value should I out there?
2) TNS_ADMIN is defined: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
3) Error ORA-06413 with this connection string:
ordSelCon.ConnectionString = "Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.9)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = TEST)));Integrated Security=no;User ID=GLF;Password=PRIMERA1"
I've checked, it's the same i've in TNSNAMES.ORA
0
leorochaAuthor Commented:
kaufmed, I don't understand your question.
0
slightwv (䄆 Netminder) Commented:
The ORA-06413 appears to be a 32Bit issue on 64Bit and the "Program Files (x86)"
https://community.oracle.com/thread/2251833

Don't worry about what Guvera posted.  That was just a Google effort on the ORA-12154 error.

What kaufmed was asking is you have multiple Oracle products installed.  It might be an ORACLE_HOME issue and it was looking at the wrong tnsnames.ora file.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
leorochaAuthor Commented:
kaufmed, yes I've ORACLE\PRODUCT\10.2.0\CLIENT_1 .... (the client I'm using to connect to a external database) and ORACLEXE\APP\ORACLE... (my XE Oracle Server for development).

Leonel
0
leorochaAuthor Commented:
slightwv, considering your comment about "32Bit issue on 64Bit...." I've changed the DefaultLocation property of the Application Folder in "File System on Target Machine" of the service setup project (the default was "Program Files (x86)"), and all works fine.

Thanks,
Leonel
0
slightwv (䄆 Netminder) Commented:
Glad it worked for you.

Oracle has issues in the Microsoft world from time to time.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

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.