Data Source=(DESCRIPTION= (ADDRESS_LIST=(ADDRESS=(
This works every time.
It just seems as though TNS isn't worth the trouble.
Tuesday, January 26, 2010
ORA-12154 TNS:could not resolve the connect identifier specified
Hey Oracle enthusiasts. Here's a fun one. I encounter this just about whenever I try to configure, unsuccessfully, TNSNames.ora for ODP.NET. Recently, I decided stopped worrying about TNS and put everything into the connection string, like so:
Data Source=(DESCRIPTION= (ADDRESS_LIST=(ADDRESS=(
This works every time.
It just seems as though TNS isn't worth the trouble.
Data Source=(DESCRIPTION= (ADDRESS_LIST=(ADDRESS=(
This works every time.
It just seems as though TNS isn't worth the trouble.
Subscribe to:
Post Comments (Atom)
4 comments:
Nice fill someone in on and this mail helped me alot in my college assignement. Say thank you you for your information.
Well I assent to but I contemplate the brief should prepare more info then it has.
Hi
Very nice and intrestingss story.
Thanks a lot for this post!
Spent the whole afternoon trying to connect my Oracle DB with powershell using the tnsnames, your trick did the trick.
Post a Comment