using tnsnames.ora without ODP.NET

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Hello Rainer,

Thanks for this , but attached image tell you error i am having.

i just replaced my connection with your string replacing id,pwd and hoststring.

"Data Source=set12.WORLD;User ID=user12;Password=pass12;"

please point in right direction. Thanks

Could you please attach the entry of your tnsnames.ora?
What happens if you run a cmd and type
tnsping set12.WORLD
?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Hello Thank you very much for the replies. I get following error

when i try with
"Data Source=WHOUSET.WORLD;User ID=user12;Password=pass12;"

Test method bcsContactCenter.Test.PersonServiceTest.ReadItemNotFoundTest threw exception:
Oracle.DataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified

Please help

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.