Oracle database connection error

[Guest]

For login screen program username and password are accepted anc check it from
oracle database. The valid username and password entered. but I got the error
"ORA-12154: TNS could not resolve service name". i am using provider for this
connection.

But the same oracle database can be connected thru power builder in the same
machine.

How to rectify the error?

Thanks in advance
S. Viswanathan

 

[Guest]

Hi,

This is the problem with your connect string. The DSN you are providing in
the connnect string is wrong. Here is an example:

add key="STR_CONN" value="Provider=MSDAORA.1;Data Source=xxxxx;User
ID=user1;Password=pwd1"

In the above string from the web.config file the Data Source name, you have
to specify correctly. The Data Source Name (DSN) is also found in your
tnsnames.ora file at your client side.

Thanks and Regards,
Piyush Thakuria
Technical Lead