Oracle database connection error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top