Avatar of LEONEL ROCHA
LEONEL ROCHA
Flag for Uruguay asked on

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
Visual Basic.NETOracle Database

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon
kaufmed

What user are you running the service as?
LEONEL ROCHA

ASKER
Local System account, but also I've used my personal account. Both with the same problem...
kaufmed

Do you have multiple home folders?
Your help has saved me hundreds of hours of internet surfing.
fblack61
guvera

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
LEONEL ROCHA

ASKER
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
LEONEL ROCHA

ASKER
kaufmed, I don't understand your question.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
LEONEL ROCHA

ASKER
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
LEONEL ROCHA

ASKER
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
slightwv (䄆 Netminder)

Glad it worked for you.

Oracle has issues in the Microsoft world from time to time.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck