-
ORA 12154: TNS could not resolve the connect identifier specified
Hi,
I am getting 'ORA 12154: TNS could not resolve the connect identifier specified' while trying to connect to oracle DSN through excel VB.
I am using below statement in excel VB to call DSN.
cnn.Open "OCI_DRMPHUB_DSN", "DRMHUB_RO_BKRHFMJE", "pass"
I tested DSN and the connection was successful. Attached the screenshot.
Please let me know what is missing that I am getting ORA 12154 error.
Thanks in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|